WARNING: pga_aggregate_limit value is too high for the amount of physical memory on the system PGA_AGGREGATE_LIMIT is 2048 MB PGA_AGGREGATE_TARGET is 604 MB. physical memory size is 3770 MB limit based on physical memory and SGA usage is 977 MB SGA_TARGET is 2416 MB 2022-10-15T00:06...
问题描述：启动数据库报错ORA-09968，且出现pga_aggregate_limitvalue is too high的告警，如下所示：系...
This is expected as the MGA is now accounted for out of the PGA. NOTE: If a value of 0 is specified for PGA_AGGREGATE_LIMIT, it means there is no limit to the aggregate PGA memory consumed by the instance. On 19c(19.7+), The value of PGA_AGGREGATE_LIMIT has some internal restricti...
Another effect of this issue is that customers can report increased PGA usage after upgrading to 18c and above. This is expected as the MGA is now accounted for out of the PGA. NOTE: If a value of 0 is specified for PGA_AGGREGATE_LIMIT, it means there is no limit to the aggregate PG...
Sessions holding the most untunable memory have their calls aborted in an attempt to get below the PGA usage specified by the PGA_AGGREGATE_LIMIT parameter. If the instance PGA usage is still too big, the sessions holding the most untunable memory will be killed....