This content has been marked as final. Show 3 replies
alter system set processes=1000 scope=spfile;Did you restart your Oracle instance after change?
If not, restart NOW.
I just restarted it and got the same results.
Since I fooled around with the Processes, I have not been able to run outside the development environment.
Could you recommend a setting for the Processes?
Could you recommend a setting for the Processes?It's depend on system requirement, but 1000 is large parameter.
Small system, 200-300 will be set at first time.