select sid,event
from v$session_wait
where event not like ‘rdbms%’ and event not like ‘SQL*Net message%’;

select sql_text
from v$sqltext_with_newlines a
where (a.hash_value, a.address) in
(select DECODE (sql_hash_value,0, prev_hash_value,sql_hash_value),DECODE (sql_hash_value, 0, prev_sql_addr, sql_address)
from v$session b WHERE b.sid = 4 )
order by piece asc;