find trace file name

来源:互联网 发布:淘宝代销可以刷信誉吗 编辑:程序博客网 时间:2024/06/06 13:17
SELECT      d.VALUE|| '/'|| LOWER (RTRIM (i.INSTANCE, CHR (0)))|| '_ora_'|| p.spid|| '.trc'AS "trace_file_name"FROM   (SELECT   p.spid  FROM   v$mystat m, v$session s, v$process pWHERE   m.statistic# = 1 AND s.SID = m.SID AND p.addr = s.paddr) p,(SELECT   t.INSTANCE  FROM   v$thread t, v$parameter vWHERE   v.NAME = 'thread'AND (v.VALUE = 0 OR t.thread# = TO_NUMBER (v.VALUE))) i,(SELECT   VALUE FROM   v$parameterWHERE   NAME = 'user_dump_dest') d/

0 0
原创粉丝点击