1.Oracle的Trace工具

<系统级别>

SET autotrace off
SET autotrace ON 
alter system set EVENTS '10046 trace name context forever,level 12';
alter system set events '10046 trace name context off';

<trace自己>

Alter session set sql_trace true|false
or
exec dbms_session.set_sql_trace(TRUE)

<trace别人>

--先查询seeion 所在的sid,serial#
SELECT v.sid,v.serial#,v.username,
       v.status,v.program,v.audsid, V.terminal
  FROM v$session v
 WHERE v.username = 'user name'
 
--跟踪别人的session
-- v.sid,v.serial#,
EXEC dbms_system.set_sql_trace_in_session(58, 1319,true);

--关闭跟踪
EXEC dbms_system.set_sql_trace_in_session(60, 1319,false);

--查询文件路径  
SELECT p1.VALUE || '\' || p2.VALUE || '_ora_' || p.spid || '.ora' filename,s.audsid
  FROM v$process p, v$session s, v$parameter p1, v$parameter p2
 WHERE p1.NAME = 'user_dump_dest'
   AND p2.NAME = 'db_name'
   AND p.addr = s.paddr
   AND s.audsid = 7739390
  
--翻译命令
$ ls *7648*
dev_ora_7648.trc
$ tkprof dev_ora_7648.trc hawk_7648_original_report.txt

--------------------------------------------