My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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.