Processes Remain In V$Process Without A Related Session ORA-00020 (Doc ID 316916.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.3 [Release 9.2 to 10.2]
Information in this document applies to any platform.
*** Checked for Relevance on 22-MAY-2012***


Symptoms

A query against the views V$SESSION and V$PROCESS  may show different results. 
Many processes in the view V$PROCESS may exist without having a related session in the view V$SESSION , so that
V$SESSION has much less entries compared to V$PROCESS .
At the  O/S level,  there are numerous processes being generated with a LOCAL=NO description .

The error ora-00020: maximum number of processes <num> exceeded
might be seen for new connections.

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