Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Listener established count increasing!!

777681Jul 20 2011 — edited Jul 27 2011
hello All,


Could anyone clarify what is the relationship between these:-


SQL> !ps -eaf | grep oracleALSMM | wc -l
56

SQL> select count(1) from v$session;

COUNT(1)
----------
76

SQL> !lsnrctl services | grep established
"DEDICATED" established:175 refused:0 state:blocked
"D000" established:0 refused:0 current:0 max:1022 state:ready

In the above, total user process count is 56, total session count:76 and at the listener "established:175". What is the relation among them.?

My parameter processes is set to 180.

After this state of listener without any doubt everything blocks. How to check, which external JDBC connection consuming all the processes ?

Please suggest how to get over from this situation. Thanks in advance,

Regards,
Amit

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 24 2011
Added on Jul 20 2011
#general-database-discussions
7 comments
2,248 views