Skip to Main Content

Oracle Database Discussions

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!

help! process keep increasing cause ora-00020 while sessions are not

1441644Apr 6 2017 — edited Apr 12 2017

Hi all

i'm facing a problem,

it's a linux environment,

oracle version is 11.2.0.4

middleware is mostly jboss

the process keep increasing  while sessions are not

we have changed the paramenter processes in spfile from 1800 to 3000, to 4000,

but we still facing the ORA-00020 problem.

i added the expire_time=10 in sqlnet.ora to use DCD. but it's not working.

does anyone have ever facing the problem like me ?

i  suspect its the middleware problem to cause this problem,but i cant find the real point, cause there are not many connect sessions.

most of the increasing process cannot find a relative session in v$session.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2017
Added on Apr 6 2017
28 comments
4,400 views