ITPub博客

首页 > 数据库 > Oracle > Granules of pga_aggregate_target 494 cannot be more than memory_target (497)

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

原创 Oracle 作者:dingzihan 时间:2014-07-24 09:36:09 0 删除 编辑
今天对数据库进行日常检查时,在数据库日志里发现以下报错信息:
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博客 ” ,链接:http://blog.itpub.net/22969361/viewspace-1225930/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-12-04

  • 博文量
    55
  • 访问量
    422152