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);