size of state objects(ktlbk) keeps increasing till 4031 is thrown (Doc ID 1638733.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Many 4031 errors are reported.

Errors in file /rs_db/oracle/admin/RS_PROD/diag/rdbms/rs_prod/RS_PROD/trace/RS_PROD_j010_2441.trc:
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^9f4ac8c0","kglHeapInitialize:temp")
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^ae1da3c","kglHeapInitialize:temp")

You see that when the database is running, the state objects in the shared pool keep on increasing.

Fro example; select  bytes, sysdate from v$sgastat where name like 'state o%'
425968 20/03/2014 12:58:02
37831768 20/03/2014 12:59:17
51050968 20/03/2014 12:59:48
60596008 20/03/2014 13:00:21
95251048 20/03/2014 13:02:13
123779248 20/03/2014 13:03:46
157915888 20/03/2014 13:05:59
216268288 20/03/2014 13:10:45
303839008 20/03/2014 13:15:56
365693848 20/03/2014 13:20:01
399075568 20/03/2014 13:21:43

 From the heap dump you see that these are from the "ktlbk" (List of blocks) state objects

Changes

 Nothing

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