COL MACHINE FORMAT A26
COL STATUS FORMAT A8
SELECT *
FROM
(
  SELECT S.MACHINE, W.SID, W.EVENT, W.WAIT_TIME, W.SECONDS_IN_WAIT, W.STATE, S.STATUS
  FROM V$SESSION S INNER JOIN V$SESSION_WAIT W ON (S.SID=W.SID)
  WHERE USERNAME ='SAE' AND W.SECONDS_IN_WAIT > 3600 AND S.STATUS <> 'KILLED'
  ORDER BY W.SECONDS_IN_WAIT DESC
)
WHERE ROWNUM < 200
/