ORA-4031 Due To Global Context Using Most Of Shared Memory
(Doc ID 2266575.1)
Last updated on MARCH 13, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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.
Changes
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 |