Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 18.104.22.168 [Release 10.2 to 11.1]
Information in this document applies to any platform.
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.
Added more CPUs to the system, or moved to a system with a higher number of processors.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms