-- sql trace 시작 alter session set sql_trace=true; -- sql 조회 select * from tb_xxx; -- sql trace 종료 alter session set sql_trace=false;
SELECT NAME,VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';