Re: Pga is growing on 11.2.2.0
- From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 14 Apr 2015 11:25:54 -0500 (CDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
