*
SQL> desc v$bh
 Name                                Null?    Type
 FILE#                                        NUMBER
 BLOCK#                                       NUMBER
 CLASS#                                       NUMBER
 STATUS                                       VARCHAR2(5)
 XNC                                          NUMBER
 FORCED_READS                                 NUMBER
 FORCED_WRITES                                NUMBER
 LOCK_ELEMENT_ADDR                            RAW(8)
 LOCK_ELEMENT_NAME                            NUMBER
 LOCK_ELEMENT_CLASS                           NUMBER
 DIRTY                                        VARCHAR2(1)
 TEMP                                         VARCHAR2(1)
 PING                                         VARCHAR2(1)
 STALE                                        VARCHAR2(1)
 DIRECT                                       VARCHAR2(1)
 NEW                                          VARCHAR2(1)
 OBJD                                         NUMBER
 TS#                                          NUMBER
*/



column event format a20
column p1 format 99999999
column p2 format 99999999
column p3 format 9999
select o.name, io.* from (
Select sw.sid,
       bh.objd obj#,
       substr(sw.event,1,20) event
        , sw.p1 p1 ,sw.p2 p2 ,sw.p3 p3
from v$bh bh,
     v$session_wait sw
Where
        sw.p1=bh.file#
    and sw.p2=bh.block#
    and ( sw.event like 'db file %' or sw.event like 'direct %')
   ) io,
    obj$ o
where io.obj# = o.obj# (+)
;