Re: Average response times, cache hits, etc.

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 27 Jun 2006 10:32:11 -0700
Message-ID: <1151429531.005550.276100@75g2000cwc.googlegroups.com>

Graham wrote:
> Thanks for the advice - my problem is, as always (!!!), I need this for
> a couple of days time and hence was hoping that someone could point me
> at the relevant database tables to select from ...

Look at the awrrpt.sql and the addmrpt.sql scripts ( rdbms/admin ) directory.

I would advise you to read some documentation about what has changed in 10g to understand what you are looking at but they are similar to statspack stuff.

If the site you are at has a DBA I would advise working with them.

The book I noted earlier ( 10g insider solutions ) might be helpful plus of course all the free oracle documentation is available at http://tahiti.oracle.com. Also very useful is http://asktom.oracle.com Received on Tue Jun 27 2006 - 12:32:11 CDT