Re: SGA_TARGET=0 but still see resize operations
From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 12 Aug 2014 12:49:00 -0400
Message-ID: <CAMVw97J+yq+6rw=r+u-P3KZSw=PvEjQgHnZoXyvOvQbp0C2dYw_at_mail.gmail.com>
The resizing will still happen under memory pressure conditions even if you don't use ASMM -- it is controlled by _MEMORY_IMM_MODE_WITHOUT_AUTOSGA parameter. So either set this parameter to false (and be prepared for potential ora-4031 errors) or see which pools are getting bumped and why and whether there is a legitimate need for more memory.
Date: Tue, 12 Aug 2014 12:49:00 -0400
Message-ID: <CAMVw97J+yq+6rw=r+u-P3KZSw=PvEjQgHnZoXyvOvQbp0C2dYw_at_mail.gmail.com>
The resizing will still happen under memory pressure conditions even if you don't use ASMM -- it is controlled by _MEMORY_IMM_MODE_WITHOUT_AUTOSGA parameter. So either set this parameter to false (and be prepared for potential ora-4031 errors) or see which pools are getting bumped and why and whether there is a legitimate need for more memory.
On Tue, Aug 12, 2014 at 12:36 PM, Michael Cunningham < napacunningham_at_gmail.com> wrote:
> I'm on 12c (12.1.0.1.0). memory_target=0 and sga_target=0. Original size
> of db_cache_size = 2253m and shared_pool_size = 600m. However, now, after
> 10 days, they are reversed. Lots of resize operations. I'm confused because
> I am under the impression the resizing should not happen with these
> settings. Has anyone else seen this or able to shed some light on this?
> BTW, in case it matters, sga_max_size = 3G.
>
> Thanks,
> Michael
>
-- Alex Fatkulin, http://afatkulin.blogspot.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 12 2014 - 18:49:00 CEST