The following is from the bestselling book
Oracle 10g Grid & Real Application
Clusters -
Oracle10g Grid Computing with RAC.
You can order it directly and save 30% here:
http://www.rampant-books.com/book_2004_1_10g_grid.htm
For those who would like to
investigate STATSPACK Oracle and the 10g AWR replace for
STATSPACK, three informative books are available from
Oracle Press:
-
Oracle High-performance
Tuning with STATSPACK - Oracle Press, by Donald K.
Burleson.
-
Oracle9i High-performance
Tuning with STATSPACK - Oracle Press, by Donald K.
Burleson.
-
Oracle10g Tuning - Rampant TechPress
The entire range of
techniques and options available for trend identification
using STATSPACK for Oracle are beyond the scope of this
book.
We will concentrate here
on examining STATSPACK reports that indicate trends in the
behavior of the data buffer pools. Average data buffer hit
ratios can be generated along two dimensions:
Either of these reports
will supply invaluable information for spotting usage
trends in the Oracle database. Change occurs in the data
buffers rapidly, and sometimes a long-term analysis will
provide clues that point to processing problems within the
database.
Almost every Oracle
database exhibits patterns that are linked to regular
processing schedules, called signatures. The following
sections will plot the average data buffer hit ratio for
an Oracle database over different intervals.
You might also enjoy
my bestselling book "Creating
a Self Tuning Oracle Database", by Rampant TechPress.
It is only $9.95 and all scripts in this tips can be
immediately downloaded.
http://www.rampant-books.com/book_2003_1_oracle9i_sga.htm
