Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number of processes in Oracle

user625850Jul 20 2012 — edited Jul 20 2012
Hi We are using single database server 10g with number of schemas working on Java application. off late we are getting ORA-00020 number of processes exceeded error and database is not taking any new connections. Already connected users are able to continue to work.

I changed the number of processes to 300 and re started the DB but very soon the number of processes are increasing. what is the reason for number of processes increase?

How can i fix this problem ?

Thanks in adv
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 17 2012
Added on Jul 20 2012
11 comments
1,565 views