Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: large pool always filling up
Kenneth Koenraadt wrote:
> On 29 Nov 2004 12:10:18 -0800, shaggy_at_popstar.com (Mr Boombastic) > wrote: > >
> > > > Moving from a dedicated server configuration to an MTS configuration > causes most of the PGA parts to move into the SGA. So MTS does need a > lager SHARED_POOL_SIZE, but this demand should be more than > outweighted by the savings in PGA. > > So the answer is quite simple : Increase your SHARED_POOL_SIZE and be > happy for the PGA saved.
Er, actually nearly all the UGA components move into the LARGE pool when MTS is configured.
So a modest increase of the shared pool is certainly in order. But the bulk of the increase should be in the large pool... and I think the OP already knows that. His concern is that his large pool keeps being filled, and how does he go about tracing the session(s) that are causing the large pool to be consumed.
HJR Received on Mon Nov 29 2004 - 15:21:29 CST