set echo off
set feedback off
set linesize 512

prompt ---------------------------------------------
prompt - Classement des attentes d' E/S de la base -
prompt ---------------------------------------------

column event  format a30
column segment_type format a10
column segment_name format a20

SELECT 
   event,
   segment_type,
   segment_name,
   file_id,block_id,
   blocks
FROM 
   dba_extents, 
   v$session_wait
WHERE 
   p1text='file#'
AND 
   p2text='block#'
AND 
   p1=file_id 
AND 
   p2 between block_id 
AND 
   block_id + blocks
ORDER BY 
   segment_type,
   segment_name;

