My Oracle Support Banner

ORA-04031 with Frequent Resizing of Shared Pool & Buffer Cache with ASMM on (Doc ID 461160.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: to
This problem can occur on any platform.
Applicable only on release.


Frequent ORA-4031 even after increasing SGA_TARGET, Shared_pool

Things observed:

1) ASMM is being used: Sga_target >0

2) 'KGH: NO ACCESS' increasing in shared pool

SQL> select * from v$sgastat where pool = 'shared pool' and (name in ('free memory', 'sql area', 'library cache', 'miscellaneous', 'row cache', 'KGH: NO ACCESS') );

We can see High  KGH: NOACCESS entries in the shared pool.


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

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