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

Thread: Oracle disconnections

  1. #1
    Join Date
    Oct 2002
    Posts
    284

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

    Thanks
    Ron

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    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:

    TRACE_LEVEL_CLIENT=ADMIN

    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:

    TRACE_DIRECTORY_CLIENT=x

    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