posted @ 2009-01-31 21:47 一江水 阅读(172) 评论(0)
编辑posted @ 2009-01-31 21:46 一江水 阅读(609) 评论(2)
编辑摘要: 显示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 一江水 阅读(364) 评论(0)
编辑