Re: Oracle question from a Sys. admin, re: Solaris performance

Sybrand Bakker wrote:
>
>
> The generic guideline as far Oracle is concerned the total amount of
> memory allotted to SGA (System Global Area, in which Oracle cache
much
> to avoid physical I/O) for all your instances shouldn't be set higher
> than 1/3rd of physical RAM, or your server will start paging and
> swapping, and this is potentially worse.
> My bet is you are way over that 33 percent.

I bet she's not... 'cause I bet all 50 are set to the default O8 cache size. :-)

Note to OP: The default cache size tends to be way too small for databases that actually do things.

jg

-- 
@home.com is bogus.
"But wait, there's more." - Robert J. Samuelson