Last updated on MAY 17, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.3 [Release 10.2]
The below errors are received in alert.log
o Errors received after changing the following:
- processes parameter from 1200 to 5000
- parallel_max_servers from 500 to 3072
- parallel_min_processes increased from 256 to 1024
o Can occur in both stand alone and RAC instances
o Top shows no concerns with memory or CPU.
o You have restarted the database(s) and no effect
The following kernel settings were checked:
project.max-lwps is set to default which is 2 billion.
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