Hi List,
We are running Oracle 11g 11.2.0.2 on windows Server 2008,i have set
memory_target to 24GB.
After a few days i see the SGA =9088 MB and PGA=15488 MB, the PGA Cache Hit %
is 76,31 , in the ADDM i see actual used memory for PGA is only 400 MB ! ,
beside this Memory Target Advisor shows that i need to increase PGA to 18586 MB
to get PGA cache hit ratio 90 %,
My question is this normal ??! how i limit the the size of PGA ? through the
time the buffer cache is decreasing for more PGA allocations !
Best wishes