My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.