Getting ORA-00020/ ORA-00018 With A High Number Of CPUs Regardless Of How High The Related DB Parameters Are Set.
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 126.96.36.199 [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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms