ORA-04031: ("shared Pool".."KKSSP^nnnn","kglseshtSegs")

(Doc ID 2151847.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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

Symptoms

There are 2 types of symptoms for this issue:

1. A session hits an ORA-4031:

OR

2. Even without ORA-4031, there is evidence "KKSSP^nnnn" type of memory is consuming lots of shared pool memory.

Example:

    ORA-04031: unable to allocate ... bytes of shared memory ("shared pool","unknown object","KKSSP^nnnn","kglseshtSegs")

 

Call stack :

    ...kkscscid_auc_eval->kksauc->kkdltob->kglpin->kglpnal->kglSessionHashInsert->kghssggr->kghalf

 

Information on most relevant allocations, from incident trace file:

    ==============================================
    TOP 20 MEMORY USES ACROSS SGA HEAP 1 - 6
    ----------------------------------------------
    "KKSSP " 12 GB 49% <<<<<<<
    ...

 

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