What is limit for processes param?

Hi,

I have oracle 8i on Solaris 8. While QA people were accessing db for load testing purpose, oracle throwed "max number processes exceeded", that time value for processes parameter was 500. Again they got the same problem. Now i have given processes param value as 10000. If give more than 10000, oracle is not starting and saying "Oracle Not Available,Shared memory realm not exists and No such file or direcotry".

What is the maximum value for processes parameter? Why it keeps on increasing everytime and i have to increase the value? When and how this process will start or allocated when the application accesses db.

Thanks in Advance,
Praveen Received on Thu Mar 06 2003 - 18:07:10 CET