如何获得跟踪文件名称

最新推荐文章于 2024-11-22 10:01:11 发布

原创最新推荐文章于 2024-11-22 10:01:11 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#thread #session #file #user #windows #unix

Database 专栏收录该内容

32 篇文章

订阅专栏

博客给出了在Unix和Windows系统下查询跟踪文件名称的SQL语句。通过对v$mystat、v$session、v$process等视图的关联查询，结合v$thread和v$parameter视图获取相关参数，最终得出跟踪文件名称。

For Unix

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

For Windows

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