SELECT s.USERNAME, s.OSUSER, sw.event, sw.state, sw.P1, sw.p2, sw.p3
  FROM v$session_wait sw, V$session s
 WHERE s.SID = sw.SID
   AND sw.event NOT IN 'SQL*Net message from client'
   AND osuser NOT IN 'SYSTEM'
 ORDER BY s.osuser