Shared Server Processes Abort With ORA-04031 (Doc ID 1408480.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.3 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

The alert file shows ORA-4031 errors and messages that Shared Server processes (with names Sxxx) are being aborted:

Wed Dec 28 00:05:51 2011
ORA-4031 : opidrv aborting process S014 ospid (1986702_1)
Wed Dec 28 00:05:55 2011
ORA-4031 : opidrv aborting process S024 ospid (2101434_1)
found dead shared server 'S003', pid = (37, 56)
found dead shared server 'S004', pid = (38, 63)
found dead shared server 'S005', pid = (42, 19)
found dead shared server 'S006', pid = (47, 238)


The resultant trace file shows that most of the shared memory is allocated by a chunk labeled as "KSN WaitID":

==============================
Memory Utilization of Subpool 1
================================


ALLOCATION                          BYTES
------------------------------ ----------
KSN WaitID                      619158744 <== consumes most of shared  memory
KGL handle                      121197568
sql area                         80270912
kglsim object batch              43002456
kglsim heap                      20893824
...

Changes

The issue occurs when Shared Servers are being stopped and restarted.

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