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

dingzihan發表於2014-07-24
今天對資料庫進行日常檢查時，在資料庫日誌裡發現以下報錯資訊：
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章