set pages 300
set lines 151
column event format a30
column p1_detail format a25
column p2_detail format a15
column p3_detail format a5
column sid format a15
column wait_time format 999999
column seconds_in_wait format 999999999
column state format a30 word_wrapped
select
A.SID ||’,’ || A.seq# sid ,
A.EVENT,
A.P1TEXT || ‘=’ || A.P1 p1_detail,
A.P2TEXT || ‘=’ || A.P2 p2_detail,
A.P3TEXT || ‘=’ || A.P3 p3_detail,
A.WAIT_TIME,
A.SECONDS_IN_WAIT,
A.STATE
from v$session_wait A
order by event
;