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.
Is this really a performance issue?
Read topics for more info go to Google.com enter "oracle listener.log"
Able was I ere I saw Elba
Yes. It is a performance issue. At present DBA complains too many connectiones opened and closed in short time.
Ask your DBA to think about MTS.
Originally Posted by ajaypatil
Why additional entry in listner.log file????
when connection session expires (v$session) why it logs entry in listner.log file. This entry looks same as when new connection is established.
Is there anyway to differentiate these entries (connection and connection expire) in listner.log file?
Click Here to Expand Forum to Full Width