PGA_AGGREGATE_LIMIT feature
in 12c limits PGA memory usage
·
The default value of PGA_AGGREGATE_LIMIT is set
to the greater of 2 GB, 200% of PGA_AGGREGATE_TARGET, and 3 MB times the
PROCESSES parameter.
·
It will
not exceed 120% of the physical memory size minus the total SGA size.
·
PGA_AGGREGATE_LIMIT cannot be set below its
default value. If a value of 0 is specified, it means there is no limit to the
aggregate PGA memory consumed by the instance.
·
If total PGA memory usage is over
PGA_AGGREGATE_LIMIT value. The sessions or processes that are consuming the
most untunable PGA memory will be terminated.
·
Recommended value for PGA_AGGREGATE_LIMIT is 0.
·
pga_aggregate_limit = 0
No comments:
Post a Comment