Processes Remain In V$Process Without A Related Session ORA-00020
(Doc ID 316916.1)
Last updated on NOVEMBER 11, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 10.2.0.3 [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