AWR Reporting
Recall that the dba_hist views are
built from their wrh$ equivalents. These views provide
the data source for a wealth of customizable reports for
identification of trends and time-series performance
optimization. This type of reporting identifies signatures
Once the DBA understands the patterns for
the important metrics, he or she can use the Oracle Database 10g
scheduler to re-allocate system resources just-in-time for the
repeating event.
All queries against the dba_hist
views require a join into the dba_hist_snapshot view,
which is the main anchor for the AWR history views. In the
following figure, the anchor view and samples of summary and
detail dba_hist views are shown:
Figure 4.13 - A sample of the dba_hist
views for the AWR
With 64 dba_hist views and thousands
of possible statistics to examine, the focus needs to be
narrowed to some commonly used tuning approaches. The following
is a list of AWR dba_hist views:
