sessions using too much of PGA: why?
Hi all, I got a 9.2.0.6.0 db running on solaris.
This db only has few connections made by an application server, and every session must be able to use a lot of PGA.
We set up the parameters
pga_aggregate_target=2000M
pgamax_size=300M
We expect every session to use less than min ( 5% * pga_aggregate_target, 50% * pgamax_size) = 100 M of PGa for every sql statement, but now we see some sessions using 136M or 165M of PGA while running only one big select statement.
Why do these sessions use more than 100 M of PGA?
Can someone tell me how this limit is handled? Is it a soft limit? Is it a theoretical limit?
thanks,
andrea