session 레벨 sql trace

1) 문제의 session 에 대한 sid, serial# 확인.

SQL> select sid, serial#,username from v$session;
SID SERIAL# USERNAME
---------- ---------- ------------------------------
214 5473 SCOTT

2) 식별된 session 에 sql trace 활성

SQL> execute dbms_monitor.session_trace_enable(214,5473);

3) 모니터링

SQL> select trace_type, primary_id, QUALIFIER_ID1, waits, binds from DBA_ENABLED_TRACES;

SELECT sid,serial#,username,sql_trace_waits,sql_trace_binds,sql_trace_plan_stats
FROM v$session
WHERE sql_trace = 'ENABLED';

4) trace 비활성

SQL> execute dbms_monitor.session_trace_disable(214,5473);