Oracle disconnections Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle disconnections

  1. #1
    Join Date
    Oct 2002

    Oracle disconnections

    hello all..

    I need to find out when exactly a particular connection is lost ...

    listener.log tells about the new connections...but there is no log file that tells about disconnections...

    so how do we find out the disconnections ?..i know one of the ways is enable auditing..., but how do we do it ?..

    any help is appreciated..


  2. #2
    Join Date
    Jul 2002
    Northampton, England
    If I understand fully what you are asking (tracing a client connection), you need to set the following in your SQLNET.ORA file on the client in question:


    or instead of ADMIN, try SUPPORT for a detailed output... The trace file will get big real quick so keep an eye on it!!

    You can also set:


    To change the default location that your trace file will get written to.

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