Listener established count increasing!!
777681Jul 20 2011 — edited Jul 27 2011hello 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