ORA-04031 errors lead to high CPU usage and DB Hang
(Doc ID 752108.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3 - Release: 10.2 to 10.2
a) You are running on Linux Itanium Platform and the database < 10.2.0.4
NOTE: The identified bug is Port specific so if running on any other platform this article will
not provide a solution.
b) The following error or similar is seen in the alert log :
ORA-04031: unable to allocate 4120 bytes of shared memory ("shared pool","update sys.aud$ set action#=...","Typecheck","kgghteInit")
The failing 'pool' and memory chunk will vary but the ORA error will be ORA-4031
c) Many OS level processes will be found to be reading the oracle executable, apparently for
dumping a stack. With a debugger, the following stack trace might be seen :
#0 0x200000000137fa81 in read () from /lib/tls/libpthread.so.0
#1 0x4000000004d7a7e0 in sskgds_getsnm ()
#2 0x4000000002766160 in skdsttpcs ()
#3 0x4000000001131920 in ksedst ()
#4 0x40000000011b0140 in ksm_4031_dump ()
d) The database appears to 'hang'
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