获取默认文件名SQL如下:
--第1种 SELECT u_Dump.Value || '/' || Lower(Db_Name.Value) || '_ora_' || V$process.Spid || Nvl2(V$process.Traceid, '_' || V$process.Traceid, NULL) || '.trc' "Trace File" FROM V$parameter u_Dump CROSS JOIN V$parameter Db_Name CROSS JOIN V$process JOIN V$session ON V$process.Addr = V$session.Paddr WHERE u_Dump.Name = 'user_dump_dest' AND Db_Name.Name = 'db_name' AND V$session.Audsid = Sys_Context('userenv', 'sessionid'); --第2种 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 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;
eg:
/data03/DEV4/db/9.2.0/admin/DEV4_mistest/udump/dev4_ora_9359834.trc
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。