Oracle优化集二
获得进程信息，选择需要跟踪的进程:SQL> select sid,serial#,username from v$session
2where username is not null;
SID SERIAL#USERNAME
---------- ---------- ------------------------------
8 2041SYS
9 437EYGLE
设置跟着:
SQL> exec dbms_system.set_sql_trace_in_session(9,437,true)
PL/SQL procedure successfully completed.
....
可以等候片刻，跟踪session执行任务,捕获sql操作...
....
停止跟踪:
SQL> exec dbms_system.set_sql_trace_in_session(9,437,false)
PL/SQL procedure successfully completed.
页:
[1]