Re: Why is buffer cache hit rate so low??

If the shared pool is large it is probably better to use v$sql over v$sqlarea, since the latter is a grouped version of the former, and with a very large shared pool the performance impact can be significant.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Rniemic wrote in message <19990607183005.07266.00001994_at_ng-fo1.aol.com>...
>Use the following select to get the queries that are causing a high amount
of
>disk reads and then hopefully you can index them better than they are now
>(depending on how large your tables are, you may need to vary the 100000 to
be
>higher or lower to get the top statements):
>
>select disk_reads, sql_text
>from v$sqlarea
>where disk_reads > 100000
>order by disk_reads desc;
>
Received on Wed Jun 09 1999 - 13:39:31 CDT