此代碼轉自eygle的站點上：

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

轉載于:https://www.cnblogs.com/anran_guojianjun/archive/2009/12/06/1618042.html

總結

以上是生活随笔為你收集整理的查看跟踪文件的地址的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。