Oracle listner.log understanding
I am using Oracle9i with COM+/IIS and MDAC2.8Sp1.
When I look at listner.log file, I can see connection log. I am verifying it against v$session table.
Problem is when v#session entry expires (session expired), it logs entry in to listner.log file as someone connected.
Please give me some head start in understanding listner.log file and what are different elements/activities are logged in it. Is it reliable to know connection load or v$session table gives correct connection count.
I am facing problem of too many connections logged in listner.log file. Connection comes and goes but count is high. I need to know if there is any issue from COM+ sever not maintaning connection pool or it is incorrect logging in listner.log file.
Click Here to Expand Forum to Full Width