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: Large DB buffer, low cache hit ratio

Re: Large DB buffer, low cache hit ratio

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 24 Jan 2001 13:30:17 -0000
Message-ID: <94mldh$nf6$1@soap.pipex.net>

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3a6cd327$1_at_news.iprimus.com.au...
> A couple of comments.

<snip>

> Go back to basic rules-of-thumb. SGA should be around 300-350Mb on your
> system, in total. Next, the Shared Pool should be/could be aound twice to
> three times the size of your buffer cache.

Do you have some docs/papers to justify this rule of thumb? (The shared pool not the sga size.) Also for the 16k block size recommendation for NT. I've been humming and hawing about NT block size for a while but can't find NT specific advice. Ixora for example seems to have plenty of Unix as opposed to NT advice.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Wed Jan 24 2001 - 07:30:17 CST

Original text of this message

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