Re: ASMM question
From: <fitzjarrell_at_cox.net>
Date: Wed, 2 Apr 2008 08:56:03 -0700 (PDT)
Message-ID: <65f5ab57-73bb-4f2d-973e-9fe074c12e43@a70g2000hsh.googlegroups.com>
Date: Wed, 2 Apr 2008 08:56:03 -0700 (PDT)
Message-ID: <65f5ab57-73bb-4f2d-973e-9fe074c12e43@a70g2000hsh.googlegroups.com>
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
> 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.
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