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;
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博客 ” ，链接：https://blog.itpub.net/35489/viewspace-417527/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
buffer busy waits
下一篇：
latch free事件的整理
请登录后发表评论
登录
全部评论
