My Oracle Support Banner

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: to - Release: 10.2 to 10.2


The following symptoms have been attributed to this issue :-

a) You are running on Linux Itanium Platform and the database <

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/
#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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.