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

From: <ethanpost_at_my-deja.com>
Date: Wed, 09 Jun 1999 23:47:16 GMT
Message-ID: <7jmue1$2gu$1@nnrp1.deja.com>

We have located the offending SQL statement, it is software related. Now the problem is trying to figure out why the statement almost always causes a physical read as opposed to finding the data in the buffer.

In article <928953877.22086.0.nnrp-07.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 09 1999 - 18:47:16 CDT