Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large DB buffer, low cache hit ratio
"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 UKReceived on Wed Jan 24 2001 - 07:30:17 CST