Re: SGA_TARGET=0 but still see resize operations
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: napacunningham@xxxxxxxxx
- Date: Tue, 12 Aug 2014 12:49:00 -0400
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@xxxxxxxxx> 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
Other related posts:
