MMON Trace generated with -- Sga Policy: Cache Below Reserve And Cant Get Memory (Doc ID 422954.1)

Last updated on MAY 26, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.
Oracle Database 10g

Symptoms


- Getting a huge trace file generated in dump destination, and it keeps growing.
- Trace file generated stating: sga policy: cache below reserve and cant get memory

Sample from the Trace:

SGA POLICY: Cache below reserve and cant get memory from any other component
GRANULE SIZE is 8388608
COMPONENT NAME : shared pool, curnum=15, usrsz=15, tgt=15, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 15
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : large pool, curnum=1, usrsz=0, tgt=1, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 1
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : java pool, curnum=7, usrsz=7, tgt=7, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 7
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : streams pool, curnum=6, usrsz=6, tgt=6, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 6
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : System Memory, curnum=69, usrsz=0, tgt=0, st=0
Number of granules in listid 0 is 69
Number of granules in listid 1 is 0
Number of granules in listid 2 is 0
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : DEFAULT buffer cache, curnum=49, usrsz=47, tgt=49, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 49
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : KEEP buffer cache, curnum=0, usrsz=0, tgt=0, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 0
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : RECYCLE buffer cache, curnum=0, usrsz=0, tgt=0, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 0
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : DEFAULT 2K buffer cache, curnum=0, usrsz=0, tgt=0, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 0
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : DEFAULT 4K buffer cache, curnum=0, usrsz=0, tgt=0, st=0
Number of granules in listid 0 is 0
Number of granules in listid 1 is 0
Number of granules in listid 2 is 0
Number of granules in listid 3 is 0
Number of granules in listid 4 is 0
COMPONENT NAME : DEFAULT 8K buffer cache, curnum=0, usrsz=0, tgt=0,


Changes

These warnings are produced by the MMON which is the background process of AWR
(Automatic Workload Repository) 10g new feature
This feature includes also Automatic Shared Memory Management feature as well.

Oracle is informing about the actual value of the db_cache_size is below the
value set in the init or the spfile for this parameter and there are no memory
free in the sga_target to increase it.
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms