column minsinwait format 999.9
SELECT LPAD(' ', (level-1)*2, ' ') || NVL(s.username, '(oracle)') AS username,
       s.osuser,
       s.inst_id, s.sid,
       s.lockwait,
       s.status,
       s.module,
       s.logon_time,
       s.seconds_in_wait/60 minsinwait --sysdate-(seconds_in_wait/60/60/24) waitstart
FROM   gv$session s
CONNECT BY PRIOR s.sid = s.blocking_session and PRIOR s.inst_id = s.blocking_instance
START WITH s.blocking_session IS NULL
/
