How Does AWR Compare Against STATSPACK?
BEGIN_INTERVAL_TIME
FILENAME PHYRDS
-------------------------
--------------------------------------
----------
25-FEB-04 12.01.06.562 AM
E:\ORACLE\ORA92\FSDEV10G\SYSTEM01.DBF
169,940
E:\ORACLE\ORA92\FSDEV10G\UNDOTBS01.DBF
26,946
E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF
483,550
E:\ORACLE\ORA92\FSDEV10G\USERS01.DBF
1,799
E:\ORACLE\ORA92\FSDEV10G\T_FS_LSQ.ORA
2,248
With a little tweaking to the reads.sql
script, reports could be generated on physical writes, read
time, write time, single block reads, and a host of other
metrics from the dba_hist_filestatxs view.
The following section explores the AWR
table contents more deeply.
Inside the Automatic Workload Repository
Tables
All of the information collected by the AWR
is taken from the x$ structures in the Oracle heap. In
Oracle Database 10g, major changes have been made to the x$
structures as well as many new and modified v$ views,
which are built from the x$ structures. The overview
presented here will start by taking a quick look at the 10g
v$ views relating to database events.
Figure 4.10 - The new 10g v$ system
event structure