Re: Max SGA size for 32-bit 9.2.0.6 on Solaris

>Free memory beyond a safety range is all wasted. Now-a-days even the
>smallest box comes with tons of memory by default. I think one should

Since I just bought my wife a new box, and then discoverd XP is a pig, I have to disagree there.

>always maximize SGA to a safe range and nobody should still be using
>32-bit and limit your SGA to a few GB while having another several,

Agree with this but: What is safe?

>or even ten's of GB idling. Basically it is use it or waste it.
>I see nothing wrong trading idle memory with a few cycles of CPU.

Oversizing SGA can cause problems too. Things have to wait around while too much housekeeping gets done. Memory usage outside the SGA can add up faster than expected.

jg

-- 
@home.com is bogus.
http://www.word-detective.com/