Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Myths
Most of the myths you posted I've not followed anyway. However, these two I
would appreciate more info about. The corporate DBAs in my company wrote a
script that checks some basic performance metrics. Two of the items that it
checks are buffer cache hit ratio and library cache hit ratio.
On 5/15/02 4:25 AM, in article
3ce21b71$0$8510$ed9e5944_at_reading.news.pipex.net, "Niall Litchfield"
<n-litchfield_at_audit-commission.gov.uk> wrote:
> Suggested list to be added to, deleted from etc
>
> Buffer cache hit ratio should be as high as possible preferably greater than
> 90%.(from the java tool we use developed in house)
>
> Library Cache hit ratio should be greater than 99% if it isn't increase the
> size of the shared pool.(ditto!)
-- Jeff Traigle traigle_at_si.umich.edu http://www-personal.si.umich.edu/~traigle/Received on Wed May 15 2002 - 07:14:20 CDT