Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Myths

Re: Oracle Myths

From: Jeff Traigle <traigle_at_si.umich.edu>
Date: Wed, 15 May 2002 12:14:20 GMT
Message-ID: <B907C95A.139FB%traigle@si.umich.edu>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US