用SQL_TRACE对Oracle进行诊断（一）

http://www.eygle.com/case/Use.sql_trace.to.Diagnose.database.htm

生成trc文件后查找可以通过数据字典表看到trace文件的位置：

SELECT
d.VALUE
|| '/'
|| LOWER (RTRIM (i.INSTANCE, CHR (0)))
|| '_ora_'
|| p.spid
|| '.trc' trace_file_name
FROM (SELECT p.spid
  FROM v$mystat m, v$session s, v$process p
  WHERE m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,
  (SELECT t.INSTANCE
     FROM v$thread t, v$parameter v
  WHERE v.NAME = 'thread'
  AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,
  (SELECT VALUE
  FROM v$parameter
  WHERE NAME = 'user_dump_dest') d