查看等待事件慢在哪个object上

最新推荐文章于 2025-01-02 19:07:55 发布

转载最新推荐文章于 2025-01-02 19:07:55 发布 · 55 阅读

本文提供了一段SQL脚本，用于查询Oracle数据库中特定会话ID (SID) 的文件顺序读取情况，通过联合使用Dba_Objects、V$session_Wait及X$bh视图来获取相关信息。

SELECT b.Sid,
      Nvl(Substr(a.Object_Name, 1, 30),
            'P1=' || b.P1 || ' P2=' || b.P2 || ' P3=' || b.P3) Object_Name,
      a.Subobject_Name,
      a.Object_Type
   FROM Dba_Objects a,
      V$session_Wait b,
          x$bh    c
WHERE c.Obj = a.Object_Id(+)
   AND b.P1 = c.File#(+)
   AND b.P2 = c.Dbablk(+)
   AND b.Event = 'db file sequential read'
   AND b.sid = 12
UNION
SELECT b.Sid,
      Nvl(Substr(a.Object_Name, 1, 30),
            'P1=' || b.P1 || ' P2=' || b.P2 || ' P3=' || b.P3) Object_Name,
      a.Subobject_Name,
      a.Object_Type
   FROM Dba_Objects a,
      V$session_Wait b,
      X$bh          c
WHERE c.Obj = a.Data_Object_Id(+)
   AND b.P1 = c.File#(+)
   AND b.P2 = c.Dbablk(+)
   AND b.Event = 'db file sequential read'
   AND b.sid = 12
ORDER BY 1;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-417527/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-417527/