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?
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
Bookmarks