| 如何获取trace文件路径 | DBA之路：OoNiceDream |

如何获取trace文件路径

作者：OoNiceDream【转载时请务必以超链接形式标明文章原始出处和作者信息】
链接：http://www.dbaroad.me/archives/2008/11/find-trace-path.html

日常维护中，我们通常会通过各种命令获得一些trace，这里总结了一下，获取TRACE文件存放的路径的两种方法：

方法一，通过查询动态性能视图：

sys@ORCL>alter database backup controlfile to trace;
 
Database altered.
 
sys@ORCL>@get_trace;
 
TRACE_FILE_NAME
------------------------------------------------------------
/u01/app/oracle/admin/orcl/udump/orcl_ora_5261.trc
 
sys@ORCL>! cat get_trace.sql
col trace_file_name for a60
 select  
 d.value||'/'||lower(rtrim(i.instance, chr(0)))||'_ora_'||p.spid||'.trc' trace_file_name
from  
 ( select p.spid  
   from sys.v$mystat m,sys.v$session s,sys.v$process p  
   where m.statistic# = 1 and s.sid = m.sid and p.addr = s.paddr) p,  
 ( select t.instance from sys.v$thread  t,sys.v$parameter  v  
   where v.name = 'thread' and (v.value = 0 or t.thread# = to_number(v.value))) i,
 ( select value from sys.v$parameter where name = 'user_dump_dest') d ;
sys@ORCL>

方法二，通过oradebug:

sys@ORCL>alter database backup controlfile to trace;
 
Database altered.
 
sys@ORCL>oradebug setmypid;
Statement processed.
sys@ORCL>oradebug tracefile_name 
/u01/app/oracle/admin/orcl/udump/orcl_ora_5261.trc
sys@ORCL>