 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
Inside the DBA_HIST Views
|
dba_hist_latch
|
dba_hist_dlm_misc
|
|
dba_hist_latch_children
|
dba_hist_cr_block_server
|
|
dba_hist_latch_parent
|
dba_hist_current_block_server
|
|
dba_hist_latch_misses_summary
|
dba_hist_class_cache_transfer
|
|
dba_hist_librarycache
|
dba_hist_active_sess_history
|
|
dba_hist_db_cache_advice
|
dba_hist_tablespace_stat
|
|
dba_hist_buffer_pool_stat
|
dba_hist_log
|
|
dba_hist_rowcache_summary
|
dba_hist_mttr_target_advice
|
|
dba_hist_sga
|
dba_hist_tbspc_space_usage
|
|
dba_hist_sgastat
|
dba_hist_service_name
|
|
dba_hist_pgastat
|
dba_hist_service_stat
|
|
dba_hist_resource_limit
|
dba_hist_service_wait_class
|
|
dba_hist_shared_pool_advice
|
dba_high_water_mark_statistics
|
Table 4.12 - dba_hist views
These views are fully documented in the
Oracle Database 10g Reference Manual. The following
sections will focus more on the dba_hist views for
time-series and exception reporting and related reports.
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
