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

Thread: which tool to trace queries on 9i

  1. 05-30-2004, 06:25 PM #1
    mozart
    mozart is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 05-30-2004, 06:34 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width