My Oracle Support Banner

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

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


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.




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

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