RE: wow lots of changes in sgastat in 11.2 versus 11.1
From: Austin Hackett <hacketta_57_at_me.com>
Date: Fri, 29 Mar 2013 13:04:56 +0000
Message-id: <DF10EAEB-C7B1-4F10-8AB8-35C282C7F46D_at_me.com>
Hi John
Apologies if this is old news, but the following MOS info may be of interest re manual memory management and SGA resizes:
Date: Fri, 29 Mar 2013 13:04:56 +0000
Message-id: <DF10EAEB-C7B1-4F10-8AB8-35C282C7F46D_at_me.com>
Hi John
Apologies if this is old news, but the following MOS info may be of interest re manual memory management and SGA resizes:
SGA Re-Sizes Occurring Despite AMM/ASMM Being Disabled (MEMORY_TARGET/SGA_TARGET=0) [ID 1269139.1]
Basically, Oracle will do SGA resizes to avoid 4031 errors, even if you are using manual memory management.
I've also observed large amounts of memory being used by KGLHD and have applied the patch Finn mentions. Unfortunately it didn't help though. I have an SR open for this, but no news at the moment.
Austin
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 29 2013 - 14:04:56 CET