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 07:30 PM.
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.
Click Here to Expand Forum to Full Width