script to find out wait event objects in oracle database.

Steps to get the wait event object name

select event,p1,p2,p3 from V$session_wait where
sid in (select sid from v$session where username='BALA');

where P1--file# P2 block number


define __FILE = &1
define __BLOCK = &2

select segment_name from dba_extents where file_id = &__FILE
and &__BLOCK between block_id and block_id + blocks - 1 and rownum = 1 ;

set echo on