Re: Pga is growing on 11.2.2.0

From: Don Seiler <don_at_seiler.us>
Date: Tue, 14 Apr 2015 11:16:46 -0500
Message-ID: <CAHJZqBDt5H7MK1DiUmiaTYrzVwq1uqSbWTuTCH6=CfZT2gw2RA_at_mail.gmail.com>

Not exactly answering your question, but your last comment about the buffer cache shrinking is why I dislike auto memory management. I set memory_target and sga_target to 0 in my prod and dev environments where I want a stable profile for app testing.

I'm probably a dinosaur and way behind in feature adoption, but I've been burned by AMM thrashing the hell out of memory in the past as well.

Don.

On Tue, Apr 14, 2015 at 8:12 AM, walid kaakati <dmarc-noreply_at_freelists.org> wrote:

> 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
>

-- 
Don Seiler
http://www.seiler.us

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 14 2015 - 18:16:46 CEST