 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
Inside the DBA_HIST Views
and s.dbid = sn.dbid
and s.instance_number =
sn.instance_number
and sn.status = 0
and sn.bl_moved = 1;
Because of the overwhelming amount of data, the
focus here will be on the dba_hist views that may be familiar
from STATSPACK. The column names are different from the STATSPACK
tables, but the types of performance data collected by these
STATSPACK tables are essentially the same as that found inside the
dba_hist views.
|
dba_hist View |
STATSPACK Table |
|
dba_hist_bg_event_summary
|
stats$bg_event_summary |
|
dba_hist_buffer_pool_statistics |
stats$buffer_pool_statistics |
|
dba_hist_filestatxs |
stats$filestatxs |
|
dba_hist_latch |
stats$latch |
|
dba_hist_latch_children |
stats$latch_children |
|
dba_hist_librarycache |
stats$librarycache |
|
dba_hist_rowcache_summary |
stats$rowcache_summary |
|
dba_hist_sgastat |
stats$sgastat |
|
dba_hist_sql_summary |
stats$sql_summary |
|
dba_hist_sysstat |
stats$sysstat |
|
dba_hist_system_event |
stats$system_event |
|
dba_hist_waitstat |
stats$waitstat |
Table 4.11 STATSPACK and dba_hist name
equivalencies
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
|
|
