ORA-4031 Due To Global Context Using Most Of Shared Memory (Doc ID 2266575.1)

Last updated on MAY 23, 2017

Applies to:

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

Symptoms

ORA-04031: unable to allocate 2976 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","KGLHD")

Allocation Request Summary Informaton
=====================================
Current information setting: 04014fff
SGA Heap Dump Interval=3600 seconds
Dump Interval=300 seconds
Last Dump Time=04/19/2017 04:14:09
Dump Count=1
Allocation request for: KGLHD
Heap: 0x6005e410, size: 2976
******************************************************
HEAP DUMP heap name="sga heap(1,1)" desc=0x6005e410
extent sz=0xfe0 alt=248 het=32767 rec=9 flg=-125 opc=0
parent=(nil) owner=(nil) nex=(nil) xsz=0x1000000 heap=(nil)
fl2=0x20, nex=(nil), dsxvers=1, dsxflg=0x0
dsx first ext=0xdd000000
latch set 1 of 2
durations enabled for this heap
reserved granules for root 0 (granule size 16777216)

 

TOP 20 MEMORY USES ACROSS SGA HEAP 1 - 2
----------------------------------------------
"Global Context " 2972 MB 57%--------------------Top consumer
"free memory " 868 MB 17%
"SQLA " 456 MB 9%
"KGLH0 " 200 MB 4%
"gcs resources " 62 MB 1%

 

Checking the current statistics of the shared pool after the error will report Global context as top consumer.

 

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