I got ORA-00020 error message saying that NUMBER OF PROCESSES (75) EXCEEDED.
- (75) is just a eg.
I read that one can increase the number of processes in init.ora to avoid this. Stop and start the service. But this keeps happening again and again.
Is there any way that I can get into database to see who is running what to kill some dead sessions, look for locking ?
Is there any query or batch processes which will tell me in advance if it is goingto crash.
I tried system manager, sys/password ...

Thanks
Sonali