-
Re: ora-00020 error - # of processses exceeded
Originally posted by daljitsb
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
Sound like a bug, is Oracle patched? What do you get after "SELECT * FROM V$VERSION;"
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|