Re: Free memory in server and session PGA memory
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Mon, 14 Nov 2011 22:57:17 +0800
Message-ID: <CAM_ddu9+LutDokxYLnU+i9V5FgpAOZ7JoGSYa_fO6t0VSMDaUQ_at_mail.gmail.com>
is pga_aggregate_target set?
I search on MOS and find blow note, it stats the interoperation problem can cause CPU spike, not sure it will cause server process not to release the allocated pga also? just a guess.
*Solaris 10 memory management conflicts with Automatic PGA Memory Management [ID 460424.1]*
Date: Mon, 14 Nov 2011 22:57:17 +0800
Message-ID: <CAM_ddu9+LutDokxYLnU+i9V5FgpAOZ7JoGSYa_fO6t0VSMDaUQ_at_mail.gmail.com>
is pga_aggregate_target set?
I search on MOS and find blow note, it stats the interoperation problem can cause CPU spike, not sure it will cause server process not to release the allocated pga also? just a guess.
*Solaris 10 memory management conflicts with Automatic PGA Memory Management [ID 460424.1]*
-- Regards Sidney Chen -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 14 2011 - 08:57:17 CST