Processes Remain In V$Process Without A Related Session ORA-00020
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 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***
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