Getting ORA-00020/ ORA-00018 With A High Number Of CPUs Regardless Of How High The Related DB Parameters Are Set. (Doc ID 1050281.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms


You might be having a server with a high number of processors (> 48 CPUs) and no matter how high the DB Processes/ Sessions parameter is set, the instance seems to run out of processes/ sessions when Parallel operations are run and ORA-00018/ ORA-00020 errors are seen.

Changes

Added more CPUs to the system, or moved to a system with a higher number of processors.

Cause

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