Describe of all DBA_HIST views 11.2.0.1 https://sites.google.com/site/oraclemonitor/dba-hist-desc-all related: monitoring I/O with metrics and ASH related: putting queries together real time: real time DBA_HIST_ACTIVE_SESS_HISTORY DBA_HIST_ASH_SNAPSHOT DBA_HIST_BASELINE DBA_HIST_BASELINE_DETAILS DBA_HIST_BASELINE_METADATA DBA_HIST_BASELINE_TEMPLATE DBA_HIST_BG_EVENT_SUMMARY DBA_HIST_BUFFERED_QUEUES DBA_HIST_BUFFERED_SUBSCRIBERS DBA_HIST_BUFFER_POOL_STAT DBA_HIST_CLUSTER_INTERCON DBA_HIST_COLORED_SQL 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_DISPATCHER DBA_HIST_DLM_MISC DBA_HIST_DYN_REMASTER_STATS DBA_HIST_ENQUEUE_STAT DBA_HIST_EVENT_HISTOGRAM -- histograms DBA_HIST_EVENT_NAME DBA_HIST_FILEMETRIC_HISTORY - alerts? DBA_HIST_FILESTATXS DBA_HIST_IC_CLIENT_STATS DBA_HIST_IC_DEVICE_STATS DBA_HIST_INSTANCE_RECOVERY DBA_HIST_INST_CACHE_TRANSFER DBA_HIST_INTERCONNECT_PINGS DBA_HIST_IOSTAT_DETAIL DBA_HIST_IOSTAT_FILETYPE DBA_HIST_IOSTAT_FILETYPE_NAME DBA_HIST_IOSTAT_FUNCTION DBA_HIST_IOSTAT_FUNCTION_NAME 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_MEMORY_RESIZE_OPS DBA_HIST_MEMORY_TARGET_ADVICE DBA_HIST_MEM_DYNAMIC_COMP DBA_HIST_METRIC_NAME DBA_HIST_MTTR_TARGET_ADVICE DBA_HIST_MUTEX_SLEEP DBA_HIST_OPTIMIZER_ENV DBA_HIST_OSSTAT DBA_HIST_OSSTAT_NAME DBA_HIST_PARAMETER DBA_HIST_PARAMETER_NAME DBA_HIST_PERSISTENT_QUEUES DBA_HIST_PERSISTENT_SUBS DBA_HIST_PGASTAT DBA_HIST_PGA_TARGET_ADVICE DBA_HIST_PLAN_OPERATION_NAME DBA_HIST_PLAN_OPTION_NAME DBA_HIST_PROCESS_MEM_SUMMARY DBA_HIST_RESOURCE_LIMIT DBA_HIST_ROWCACHE_SUMMARY DBA_HIST_RSRC_CONSUMER_GROUP DBA_HIST_RSRC_PLAN 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 - alerts? , pretty much worthless unless interesting alerts set DBA_HIST_SESS_TIME_STATS - ??? doesn't look that intersting DBA_HIST_SGA DBA_HIST_SGASTAT DBA_HIST_SGA_TARGET_ADVICE DBA_HIST_SHARED_POOL_ADVICE DBA_HIST_SHARED_SERVER_SUMMARY DBA_HIST_SNAPSHOT DBA_HIST_SNAP_ERROR DBA_HIST_SQLBIND DBA_HIST_SQLCOMMAND_NAME DBA_HIST_SQLSTAT DBA_HIST_SQLTEXT DBA_HIST_SQL_BIND_METADATA DBA_HIST_SQL_PLAN DBA_HIST_SQL_SUMMARY DBA_HIST_SQL_WORKAREA_HSTGRM - low opt sz, high opt sz, opt execs, one pass exexs, multi pass execs DBA_HIST_STAT_NAME DBA_HIST_STREAMS_APPLY_SUM DBA_HIST_STREAMS_CAPTURE DBA_HIST_STREAMS_POOL_ADVICE DBA_HIST_SYSMETRIC_HISTORY - alerts? 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_TOPLEVELCALL_NAME DBA_HIST_UNDOSTAT DBA_HIST_WAITCLASSMET_HISTORY - alerts? DBA_HIST_WAITSTAT DBA_HIST_WR_CONTROL other: jobs rman monitoring metrics and load current |