Re: Pga is growing on 11.2.2.0

From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Tue, 14 Apr 2015 11:25:54 -0500 (CDT)
Message-ID: <aa1a78781be0633d45e9c79ecb0bb56d.squirrel_at_society.servebeer.com>



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
Received on Tue Apr 14 2015 - 18:25:54 CEST

Original text of this message