trace.sql
SVRMGR> SELECT sid, serial#, osuser 2> FROM v$session 3> WHERE osuser = 'indy'; SID SERIAL# OSUSER ---------- ---------- --------------- 7 6784 indy 1 row selected. ==================================================== REM Now you can start tracing for user "indy" as follows: ==================================================== SVRMGR> EXECUTE dbms_system.set_sql_trace_in_session(7,6784,TRUE); Statement processed. ==================================================== REM To stop tracing do as follows: ==================================================== SVRMGR> EXECUTE dbms_system.set_sql_trace_in_session(7,6784,FALSE); Statement processed. ==================================================== REM To enable SQL tracing in stored procedures, use this SQL statement: ==================================================== DBMS_SESSION.SET_SQL_TRACE (TRUE);