how to trace other session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: how to trace other session

  1. #1
    Join Date
    Jun 2006
    Posts
    51

    how to trace other session

    I want to trace user session when she running reports to trace all the sql statements how to do it?

    Thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    dbms_system.set_ev

  3. #3
    Join Date
    Feb 2003
    Posts
    63

    Could Try this

    exec dbms_system.set_sql_trace_in_session('sid','serial#',TRUE);

  4. #4
    Join Date
    Jun 2006
    Location
    Wales, UK
    Posts
    62
    Don't forget to switch the tracing off when you've finished

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by craigdba
    exec dbms_system.set_sql_trace_in_session('sid','serial#',TRUE);

    How would you set the trace number and level in the above query???

    you can set them in
    Exec dbms_system.set_ev(sid,serial#,trace number,trace level);
    "What is past is PROLOGUE"

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you dont, it does a basic sql_trace

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