Home Privacy Policy Feedback Link to us Site Map

Oracle/PLSQL: ORA-00020 Error


Error:

ORA-00020: maximum number of processes num exceeded

Cause:

You tried to execute a statement that requested a resource. Since the maximum number of processes have been reached, Oracle will not process any new requests.

Action:

The options to resolve this Oracle error are:
  1. You can wait a few minutes and try to re-execute the statement(s).
  2. You can shut down Oracle, increase the PROCESSES parameter in the initialization parameter file, and restart Oracle.