As per documentation :
"This feature limits the total amount of Program Global Area (PGA) that an instance can allocate, using a parameter called
This feature is important for consolidation because, without a hard limit, the instance can become unstable due to excessive paging. Excessive paging is one of the leading causes of instance eviction in an Oracle RAC database and can cause a multitude of performance and stability problems."
Best Regards,
Paulo Portugal
"This feature limits the total amount of Program Global Area (PGA) that an instance can allocate, using a parameter called
PGA_AGGREGATE_LIMIT. When the instance has allocated the PGA_AGGREGATE_LIMIT amount of PGA, sessions with the highest amount of allocated PGA are stopped until the limit is complied with.This feature is important for consolidation because, without a hard limit, the instance can become unstable due to excessive paging. Excessive paging is one of the leading causes of instance eviction in an Oracle RAC database and can cause a multitude of performance and stability problems."
Best Regards,
Paulo Portugal
No comments:
Post a Comment