SGA_TARGET=0 but still see resize operations
From: Michael Cunningham <napacunningham_at_gmail.com>
Date: Tue, 12 Aug 2014 09:36:51 -0700
Message-ID: <CAPt39ttMV_5eBtxX2miqzFsfdRvZr8mPR=xy3Nc+1CdLEOiMUA_at_mail.gmail.com>
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.
Date: Tue, 12 Aug 2014 09:36:51 -0700
Message-ID: <CAPt39ttMV_5eBtxX2miqzFsfdRvZr8mPR=xy3Nc+1CdLEOiMUA_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 12 2014 - 18:36:51 CEST