Oracle Database Discussions

Hi All,

I have one question - what are the methods through which I can get the idea about no.of connection listen by listener?

Today when I checked lsnrctl serv command I can see "established=320 and refused=0 ,state=ready". So I assumed as of now 320 are active connection on my database.

But when I check current_utilization for Process and session it has big gap, processes=147 and session=151. Also when I list the no.of oracle process running on OS (ps -ef | grep oracle<SID> | wc -l ) it showing 121 only.


I am confused now. Can you please guide what is right way to get the no.of connection listen at any time on the DB server ?


Thanks in advance...