Re: Buffer cache hits %

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 15 Jul 1999 20:50:58 +0100
Message-ID: <932070540.26713.0.nnrp-13.9e984b29@news.demon.co.uk>

See my web-site:

Miscellaneous -> Old Wives Tales -> item no. 2

If you want a higher buffer hit ratio it costs about 200 bytes of script and 2 data blocks.

To check if your database is behaving sensibly review v$sql to see if any statements are unreasonably expensive for the task they appear to be doing.

Check also any stats to do with tablescans except for the direct reads and/or rowid ranges.

Your shared pool looks a bit extreme, by the way.

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

Jiliang Chiu wrote in message ...
Kevin:

The hit ratio should be 95 - 100%. Received on Thu Jul 15 1999 - 14:50:58 CDT