Issue: ORA-04031: unable to allocate ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^d60c1b2d","kglHeapInitialize:temp")
Solution: Download and apply Patch:13456573 for non-Exadata database.
References -
ORA-04031 in 11g & 11gR2, Excess "KGH: NO ACCESS" Memory Allocation ( Doc ID 1127833.1 )
Severe Performance Problems Due to Sudden drop/resize/shrink of buffer cache ( Doc ID 1344228.1 )
ORA-4031 Against Shared Pool With Huge Memory Allocations To KGLH0 ( Doc ID 1621829.1 )
ORA-04031 Due To Excessive Growth In KGLH0 Heaps ( Doc ID 1351675.1 )
ORA-04031 in 11g & 11gR2, Excess "KGH: NO ACCESS" Memory Allocation ( Doc ID 1127833.1 )
Severe Performance Problems Due to Sudden drop/resize/shrink of buffer cache ( Doc ID 1344228.1 )
ORA-4031 Against Shared Pool With Huge Memory Allocations To KGLH0 ( Doc ID 1621829.1 )
ORA-04031 Due To Excessive Growth In KGLH0 Heaps ( Doc ID 1351675.1 )
No comments:
Post a Comment