Re: ASMM question
Date: Wed, 2 Apr 2008 08:56:03 -0700 (PDT)
On Apr 2, 10:49 am, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> sga_target_size = 4g
> sga_max_size = 6g
> When the instance starts, how much memory will it try to allocate? 6g or
> 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.
ipcs reports what is actually allocated, which is the sga_target_size. sga_max_size is your 'wiggle room' for dynamic adjustments.
David Fitzjarrell Received on Wed Apr 02 2008 - 10:56:03 CDT