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 to [Release 9.2 to 10.2]
Information in this document applies to any platform.
*** Checked for Relevance on 22-MAY-2012***


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.


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