which tool to trace queries on 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: which tool to trace queries on 9i

  1. #1
    Join Date
    Mar 2004
    Posts
    55

    which tool to trace queries on 9i

    Could someone advise me what tool is available in oracle 9i that would allow me to trace queries being run against a database. I wish to see the exact sql query being run by an application using my oracle database.

    Is it possible to speicify which user you wish to trace?

    Thankyou for your time
    Last edited by mozart; 05-30-2004 at 06:30 PM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    find the sid and the serial number for that user session, use dbms_system.set_sql_trace_in_session and you will get your trace files then use tkprof to trace it.

    If you want this all the time use a logon trigger for that user to set this.

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