Oracle常见面试题及答案详解5

会计考友

5.    如何跟踪某个session的SQL
5 J2 d+ Y$ Z/ j* i8 _利用TRACE 跟踪
* g  H) t5 ~0 F8 p# ]  ]( l  ALTER SESSION SET SQLTRACE ON;
* A) w' j0 d) E: G2 z0 I& _  COLUMN SQL format a200;
' S+ O* {, r: R; W  SELECT   machine, sql_text SQL
      FROM v$sqltext a, v$session b
- Q3 G. m+ v0 T+ q6 h' l9 g* k6 |     WHERE address = sql_address
       AND machine = ’&A’
  ORDER BY hash_value, piece;
  
2 G+ I4 @3 _* l6 U5 |exec dbms_system.set_sql_trace_in_session(sid,serial#,&sql_trace);  
select sid,serial# from v$session where sid = (select sid from v$mystat where rownum = 1);  
exec dbms_system.set_ev(&sid,&serial#,&event_10046,&level_12,’’);