今天对数据库进行日常检查时，在数据库日志里发现以下报错信息：
WARNING: Granules of pga_aggregate_target 494 cannot be more than memory_target (497) - sga_target (0) or min_sga (11)
OS：linux server release 6.4
RAC 11.2.0.3 两个节点 ASM

SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 63616M
sga_target big integer 0
SQL> show parameter pga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 0

SQL> show parameter memory

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 63616M
memory_target big integer 63616M
shared_memory_address integer 0

Symptoms
The following message is reported in the alert log:
下面是告警日志里的信息：
WARNING: Granules of pga_aggregate_target %d cannot be more than memory_target (%d) - sga_target (%d) or min_sga(%d)

Changes
The MEMORY_TARGET and SGA_MAX_SIZE or SGA_TARGET parameters are set.
Cause
This warning message is raised because the MEMORY_TARGET/MEMORY_MAX_TARGET and SGA_MAX_SIZE/SGA_TARGET parameters are set the same. However, in Oracle 11g the MEMORY_TARGET parameter defines the total amount of memory that Oracle can use, which incorporates both SGA and PGA areas. Therefore if these are set the same as the SGA_MAX_SIZE/SGA_TARGET parameters then this leaves no memory available for the PGA, and hence this warning message is raised.
原因：这个告警信息产生是因为MEMORY_TARGET/MEMORY_MAX_TARGET 和 SGA_MAX_SIZE/SGA_TARGET参数被设置为相同的。然而，在11GOracle中，MEMORY_TARGET参数定义Oracle可以用的总的内存（包括SGA和PGA）。因此，如果SGA_MAX_SIZE/SGA_TARGET 被设置为相同的话，那么PGA就没有内存可用，告警信息就产生了。
Solution
Ensure that the MEMORY_TARGET/MEMORY_MAX_TARGET parameter settings are set to at least the sum of SGA_MAX_SIZE/SGA_TARGET plus the PGA_AGGREGATE_TARGET parameter.

解决方法：确保MEMORY_TARGET/MEMORY_MAX_TARGET参数设置为sga_max_size/sga_target 加上pga_aggregate_target的总数。

ITPub博客

Granules of pga_aggregate_target 494 cannot be more than memory_target (497)

最新文章