Below query will results the current wait event details in oracle database.

select a.sid,substr(b.username,1,10) username,substr(b.osuser,1,10) osuser,
 substr(b.program||b.module,1,15) program,substr(b.machine,1,22) machine,
 a.event,a.p1,b.sql_hash_value
from v$session_wait a,V$session b
where b.sid=a.sid
and a.event not in('SQL*Net message from client','SQL*Net message to client',
 'smon timer','pmon timer')
and username is not null
order by 6
/