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