7 /
Procedure created.
SQL> select sid,serial# from v$session where username='SCOTT'; -->获得当前用户的sid,serial#
SID SERIAL#
---------- ----------
1084 938
SQL> exec dbms_monitor.session_trace_enable(session_id=>1084,serial_num=>938); -->对当前的session启用跟踪
SQL> exec ins_t(31,62); -->执行存储过程
PL/SQL procedure successfully completed.
SQL> exec ins_t(32,64);
PL/SQL procedure successfully completed.
SQL> exec dbms_monitor.session_trace_disable(session_id=>1084,serial_num=>938); -->关闭对session的跟踪
PL/SQL procedure successfully completed.