ASMM question
From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Wed, 02 Apr 2008 15:49:54 GMT
Message-ID: <CWNIj.12884$Eq.917@trnddc05>
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