ASMM question

From: Chuck <>
Date: Wed, 02 Apr 2008 15:49:54 GMT
Message-ID: <CWNIj.12884$Eq.917@trnddc05>

sga_target_size = 4g
sga_max_size = 6g

When the instance starts, how much memory will it try to allocate? 6g or 4g?

If I run "show sga" on the instance it says total sga size is 6g. If I run "ipcs -ma" on the o/s (solaris 10) it shows the shared memory segment as being only 4g.

I'm a little confused as to what's really being allocated as there seems to be some contradiction here.

TIA. Received on Wed Apr 02 2008 - 10:49:54 CDT

Original text of this message