If the PGA_AGGREGATE_LIMIT value is exceeded, Oracle Database aborts or terminates the sessions or processes that are consuming the most PGA memory.
Abortion and termination of sessions and processes are based on the following conditions:
■Sessions and processes consuming the most PGA memory are aborted.
■If PGA memory usage is still over the PGA_AGGREGATE_LIMIT, then sessions and processes consuming the most PGA memory are terminated.
■Parallel queries are treated as a single unit.
■User sessions in consumer groups are treated based on the percentage of PGA memory specified for the consumer group in the resource plan.
■SYS and other critical background processes are not subject to terminations.
The V$PGASTAT view contains statistics about the number of sessions that are aborted or terminated due to excessive PGA memory usage since the database was started.
1* select name,value,un