Re: Pga is growing on 11.2.2.0

From: goran bogdanovic <goran00_at_gmail.com>
Date: Mon, 27 Apr 2015 17:26:13 +0200
Message-ID: <CAGyPXK4s+tPY-pEjL=70N89YCzoTNd6YyoZChgyu6=xcw03axg_at_mail.gmail.com>

not quite ... I am not big fan of it, but using minimal values for specific pools, AMM can still do a decent job

On Tue, Apr 14, 2015 at 11:59 PM, Ls Cheng <exriscer_at_gmail.com> wrote:

> +1
>
> AMM is a piece of junk, last customer had 8GB memory_target and after a
> week AMM set db_cache_size to 64M.. uh oh
>
> On Tue, Apr 14, 2015 at 6:25 PM, Rich Jesse <
> rjoralist3_at_society.servebeer.com> wrote:
>
>> Don writes:
>>
>> > 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.
>>
>> Dinosaurs rock, AMM resizing does not. I had fun when a 3rd party app not
>> using binds caused the library cache to grow to more than 11GB. The
>> instance would effectively hang for 10 minutes when tables had stats
>> collected and then attempted to invalidate all affected 250K+ cursors.
>> Good
>> times...
>>
>> Rich
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>

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

Received on Mon Apr 27 2015 - 17:26:13 CEST