"오라클 AWR"의 두 판 사이의 차이
DB CAFE
(→AWR 뷰) |
|||
8번째 줄: | 8번째 줄: | ||
* DBA_HIST_ACTIVE_SESS_HISTORY | * DBA_HIST_ACTIVE_SESS_HISTORY | ||
——— | ——— | ||
+ | |||
+ | Oracle Database » Useful Tables and Views » ASH Views | ||
+ | VIEW_NAME | ||
+ | |||
+ | DBA_HIST_ACTIVE_SESS_HISTORY | ||
+ | DBA_HIST_BASELINE | ||
+ | DBA_HIST_BG_EVENT_SUMMARY | ||
+ | DBA_HIST_BUFFERED_QUEUES | ||
+ | DBA_HIST_BUFFERED_SUBSCRIBERS | ||
+ | DBA_HIST_BUFFER_POOL_STAT | ||
+ | DBA_HIST_COMP_IOSTAT | ||
+ | DBA_HIST_CR_BLOCK_SERVER | ||
+ | DBA_HIST_CURRENT_BLOCK_SERVER | ||
+ | DBA_HIST_DATABASE_INSTANCE | ||
+ | DBA_HIST_DATAFILE | ||
+ | DBA_HIST_DB_CACHE_ADVICE | ||
+ | DBA_HIST_DLM_MISC | ||
+ | DBA_HIST_ENQUEUE_STAT | ||
+ | DBA_HIST_EVENT_NAME | ||
+ | DBA_HIST_FILEMETRIC_HISTORY | ||
+ | DBA_HIST_FILESTATXS | ||
+ | DBA_HIST_INSTANCE_RECOVERY | ||
+ | DBA_HIST_INST_CACHE_TRANSFER | ||
+ | DBA_HIST_JAVA_POOL_ADVICE | ||
+ | DBA_HIST_LATCH | ||
+ | DBA_HIST_LATCH_CHILDREN | ||
+ | DBA_HIST_LATCH_MISSES_SUMMARY | ||
+ | DBA_HIST_LATCH_NAME | ||
+ | DBA_HIST_LATCH_PARENT | ||
+ | DBA_HIST_LIBRARYCACHE | ||
+ | DBA_HIST_LOG | ||
+ | DBA_HIST_METRIC_NAME | ||
+ | DBA_HIST_MTTR_TARGET_ADVICE | ||
+ | DBA_HIST_OPTIMIZER_ENV | ||
+ | DBA_HIST_OSSTAT | ||
+ | DBA_HIST_OSSTAT_NAME | ||
+ | DBA_HIST_PARAMETER | ||
+ | DBA_HIST_PARAMETER_NAME | ||
+ | DBA_HIST_PGASTAT | ||
+ | DBA_HIST_PGA_TARGET_ADVICE | ||
+ | DBA_HIST_PROCESS_MEM_SUMMARY | ||
+ | DBA_HIST_RESOURCE_LIMIT | ||
+ | DBA_HIST_ROWCACHE_SUMMARY | ||
+ | DBA_HIST_RULE_SET | ||
+ | DBA_HIST_SEG_STAT | ||
+ | DBA_HIST_SEG_STAT_OBJ | ||
+ | DBA_HIST_SERVICE_NAME | ||
+ | DBA_HIST_SERVICE_STAT | ||
+ | DBA_HIST_SERVICE_WAIT_CLASS | ||
+ | DBA_HIST_SESSMETRIC_HISTORY | ||
+ | DBA_HIST_SESS_TIME_STATS | ||
+ | DBA_HIST_SGA | ||
+ | DBA_HIST_SGASTAT | ||
+ | DBA_HIST_SGA_TARGET_ADVICE | ||
+ | DBA_HIST_SHARED_POOL_ADVICE | ||
+ | DBA_HIST_SNAPSHOT | ||
+ | DBA_HIST_SNAP_ERROR | ||
+ | DBA_HIST_SQLBIND | ||
+ | DBA_HIST_SQLSTAT | ||
+ | DBA_HIST_SQLTEXT | ||
+ | DBA_HIST_SQL_BIND_METADATA | ||
+ | DBA_HIST_SQL_PLAN | ||
+ | DBA_HIST_SQL_SUMMARY | ||
+ | DBA_HIST_SQL_WORKAREA_HSTGRM | ||
+ | DBA_HIST_STAT_NAME | ||
+ | DBA_HIST_STREAMS_APPLY_SUM | ||
+ | DBA_HIST_STREAMS_CAPTURE | ||
+ | DBA_HIST_STREAMS_POOL_ADVICE | ||
+ | DBA_HIST_SYSMETRIC_HISTORY | ||
+ | DBA_HIST_SYSMETRIC_SUMMARY | ||
+ | DBA_HIST_SYSSTAT | ||
+ | DBA_HIST_SYSTEM_EVENT | ||
+ | DBA_HIST_SYS_TIME_MODEL | ||
+ | DBA_HIST_TABLESPACE_STAT | ||
+ | DBA_HIST_TBSPC_SPACE_USAGE | ||
+ | DBA_HIST_TEMPFILE | ||
+ | DBA_HIST_TEMPSTATXS | ||
+ | DBA_HIST_THREAD | ||
+ | DBA_HIST_UNDOSTAT | ||
+ | DBA_HIST_WAITCLASSMET_HISTORY | ||
+ | DBA_HIST_WAITSTAT | ||
+ | DBA_HIST_WR_CONTROL |
2019년 4월 5일 (금) 07:05 판
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
AWR 뷰[편집]
- DBA_HIST_SNAPSHOT
- DBA_HIST_SQLSTAT
- DBA_HIST_SYSSTAT
- DBA_HIST_SEG_STAT
- DBA_HIST_SEG_STAT_OBJ
- DBA_HIST_SQLTEXT
- DBA_HIST_ACTIVE_SESS_HISTORY
———
Oracle Database » Useful Tables and Views » ASH Views VIEW_NAME
DBA_HIST_ACTIVE_SESS_HISTORY DBA_HIST_BASELINE DBA_HIST_BG_EVENT_SUMMARY DBA_HIST_BUFFERED_QUEUES DBA_HIST_BUFFERED_SUBSCRIBERS DBA_HIST_BUFFER_POOL_STAT DBA_HIST_COMP_IOSTAT DBA_HIST_CR_BLOCK_SERVER DBA_HIST_CURRENT_BLOCK_SERVER DBA_HIST_DATABASE_INSTANCE DBA_HIST_DATAFILE DBA_HIST_DB_CACHE_ADVICE DBA_HIST_DLM_MISC DBA_HIST_ENQUEUE_STAT DBA_HIST_EVENT_NAME DBA_HIST_FILEMETRIC_HISTORY DBA_HIST_FILESTATXS DBA_HIST_INSTANCE_RECOVERY DBA_HIST_INST_CACHE_TRANSFER DBA_HIST_JAVA_POOL_ADVICE DBA_HIST_LATCH DBA_HIST_LATCH_CHILDREN DBA_HIST_LATCH_MISSES_SUMMARY DBA_HIST_LATCH_NAME DBA_HIST_LATCH_PARENT DBA_HIST_LIBRARYCACHE DBA_HIST_LOG DBA_HIST_METRIC_NAME DBA_HIST_MTTR_TARGET_ADVICE DBA_HIST_OPTIMIZER_ENV DBA_HIST_OSSTAT DBA_HIST_OSSTAT_NAME DBA_HIST_PARAMETER DBA_HIST_PARAMETER_NAME DBA_HIST_PGASTAT DBA_HIST_PGA_TARGET_ADVICE DBA_HIST_PROCESS_MEM_SUMMARY DBA_HIST_RESOURCE_LIMIT DBA_HIST_ROWCACHE_SUMMARY DBA_HIST_RULE_SET DBA_HIST_SEG_STAT DBA_HIST_SEG_STAT_OBJ DBA_HIST_SERVICE_NAME DBA_HIST_SERVICE_STAT DBA_HIST_SERVICE_WAIT_CLASS DBA_HIST_SESSMETRIC_HISTORY DBA_HIST_SESS_TIME_STATS DBA_HIST_SGA DBA_HIST_SGASTAT DBA_HIST_SGA_TARGET_ADVICE DBA_HIST_SHARED_POOL_ADVICE DBA_HIST_SNAPSHOT DBA_HIST_SNAP_ERROR DBA_HIST_SQLBIND DBA_HIST_SQLSTAT DBA_HIST_SQLTEXT DBA_HIST_SQL_BIND_METADATA DBA_HIST_SQL_PLAN DBA_HIST_SQL_SUMMARY DBA_HIST_SQL_WORKAREA_HSTGRM DBA_HIST_STAT_NAME DBA_HIST_STREAMS_APPLY_SUM DBA_HIST_STREAMS_CAPTURE DBA_HIST_STREAMS_POOL_ADVICE DBA_HIST_SYSMETRIC_HISTORY DBA_HIST_SYSMETRIC_SUMMARY DBA_HIST_SYSSTAT DBA_HIST_SYSTEM_EVENT DBA_HIST_SYS_TIME_MODEL DBA_HIST_TABLESPACE_STAT DBA_HIST_TBSPC_SPACE_USAGE DBA_HIST_TEMPFILE DBA_HIST_TEMPSTATXS DBA_HIST_THREAD DBA_HIST_UNDOSTAT DBA_HIST_WAITCLASSMET_HISTORY DBA_HIST_WAITSTAT DBA_HIST_WR_CONTROL