I am getting
ora-00020 error - # of processses exceeded
Oracle 8.1.6 resides on win200ok server.

I have increased the # of processes in init file from 200 to 600. It worked for 2 days fine, now its exceeding 600 proceeses and giving me ora-00020 error again.

I am using profiles to apply limits

sessions_per_user 8
cpu_per_session 1000000
cpu_per_call 1000000
connect_time unlimited
idle_time 60
logical_reads_per_session unlimited
logical_reads_per_call unlimited
composite_limit 2000000
private_sga unlimited

Still ora-00020 error happening. Is there anything apart from digging code to find any loose/open processes.

Any help is much appreciated.

-D