Re: Buffer cache hits %

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 - 21:50:58 CEST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]