ORA-04031 errors lead to high CPU usage and DB Hang (Doc ID 752108.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3 - Release: 10.2 to 10.2

Symptoms

The following symptoms have been attributed to this issue :-

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'

Cause

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 hundreds of Community platforms