Aertlog:Thu Jun 25 16:27:072015
WARNING: Granules ofpga_aggregate_target 200 cannot be more than memory_target (201) -sga_target (0) or min_sga (5)
Thu Jun 25 16:33:112015
WARNING: Granules ofpga_aggregate_target 200 cannot be more than memory_target (201) -sga_target (0) or min_sga (5)
Thu Jun 25 16:54:422015
WARNING: Granules ofpga_aggregate_target 200 cannot be more than memory_target (201) -sga_target (0) or min_sga (5)
Thu Jun 25 17:00:452015
WARNING: Granules ofpga_aggregate_target 200 cannot be more than memory_target (201) -sga_target (0) or min_sga (5)
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ -----------------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 102912M
sga_target big integer 0
SQL> show parameter mem
NAME TYPE VALUE
------------------------------------ -----------------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 102912M
memory_target big integer 102912M
shared_memory_address integer 0
SQL> show parameter pga
NAME TYPE VALUE
------------------------------------ -----------------------------------------
pga_aggregate_target biginteger 0
SQL>
参考:
WARNING: GRANULES OFPGA_AGGREGATE_TARGET CANNOT BE MORE THAN MEMORY_TARGET (文档 ID970274.1) 转到底部转到底部
In thisDocument
Symptoms
Changes
Cause
Solution
APPLIESTO:
Oracle Database - EnterpriseEdition - Version 11.1.0.6 and later
Information in this documentapplies to any platform.
***Checked for relevance on06-Aug-2014***
SYMPTOMS
The following message isreported in the alert log:
WARNING: Granules ofpga_aggregate_target %d cannot be more than memory_target (%d) -sga_target (%d) or min_sga(%d)
CHANGES
The MEMORY_TARGET andSGA_MAX_SIZE or SGA_TARGET parameters are set.
CAUSE
This warning message israised because the MEMORY_TARGET/MEMORY_MAX_TARGET andSGA_MAX_SIZE/SGA_TARGET parameters are set the same.
However, in Oracle 11g theMEMORY_TARGET parameter defines the total amount of memory thatOracle can use, which incorporates both SGA and PGA areas.
Therefore if these are setthe same as the SGA_MAX_SIZE/SGA_TARGET parameters then this leavesno memory available for the PGA, and hence this warning message israised.
SOLUTION
Ensure that theMEMORY_TARGET/MEMORY_MAX_TARGET parameter settings are set to atleast the sum of SGA_MAX_SIZE/SGA_TARGET plus thePGA_AGGREGATE_TARGET parameter.