My Oracle Support Banner

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

Last updated on JULY 16, 2019

Applies to:

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


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


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


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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