Oracle listner.log understanding
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle listner.log understanding

Hybrid View

  1. #1
    Join Date
    Nov 2005
    Posts
    4

    Angry 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.

  2. #2
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    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

  3. #3
    Join Date
    Nov 2005
    Posts
    4

    Performance Issue...

    Yes. It is a performance issue. At present DBA complains too many connectiones opened and closed in short time.

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Quote Originally Posted by ajaypatil
    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.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Nov 2005
    Posts
    4

    Talking 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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width