// Oracle error reference

ORA-00020: maximum number of processes exceeded

The instance reached its PROCESSES limit, so it can't start a server process for a new connection. Usually too many connections from pools.

Error code
ORA-00020
Category
Space, memory and limits
Error message
maximum number of processes (string) exceeded

What it means

With dedicated servers each connection uses an operating-system process, and the PROCESSES parameter caps how many the instance may have. ORA-00020 means that cap is reached; the full 19c message is maximum number of processes (string) exceeded. Often even administrators can't connect normally.

Common causes

  • Connection pools or applications opening more connections than the limit, or leaking them.
  • A PROCESSES setting too low for the number of users.

How to fix it

  1. Check usage.

    SELECT resource_name, current_utilization, max_utilization, limit_value
    FROM v$resource_limit WHERE resource_name = 'processes';
  2. Reduce connections: cap pool sizes, close idle sessions, or use shared servers or DRCP for many short connections.

  3. Raise the limit and restart.

    ALTER SYSTEM SET processes = 1000 SCOPE = SPFILE;

Related errors

More space, memory and limits errors

The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.

// fewer errors, faster fixes

Work on Oracle in SQLly

A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.