查看等待事件
摘要: 显示latch及热点对象(速度较慢)
select sw.sid, event, l.name, de.segment_name from v$session_wait sw, v$latch l, dba_extents de
where event not like '%SQL%' and event not like '%rdbms%' and event not like '%mon%'
and sw.p2 = l.latch#(+) and sw.p1 = de.file_id(+) and p2 between de.block_id and de.block_id + de.blocks - 1;
阅读全文
posted @
2009-01-31 19:20 一江水 阅读(363) |
评论 (0) 编辑