My Oracle Support Banner

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

Last updated on OCTOBER 08, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.