select sid, seq#, wait_time, seconds_in_wait, state, event, e.segment_name, e.partition_name
from v$session_wait sw, dba_extents e where sid = &1
and e.file_id = p1 and p2 between e.block_id and e.block_id+e.blocks-1
/
