select /*+rule */ s.sid, s.username, w.event, o.owner, o.segment_name, o.segment_type, 
o.partition_name, w.seconds_in_wait seconds, w.state 
from v$session_wait w, v$session s, dba_extents o 
where w.event in (select name from v$event_name where parameter1 = 'file#' 
and parameter2 = 'block#' and name not like 'control%') 
and o.owner <> 'sys' and w.sid = s.sid and w.p1 = o.file_id and w.p2 >= o.block_id and w.p2 < o.block_id + o.blocks

版权声明：本文为博主原创文章，未经博主允许不得转载。