Sessions

SELECT sid, STATUS, PROCESS, PROGRAM, LOGON_TIME
  FROM v$session 
  WHERE sid > 1;

oder

SELECT SID,SERIAL#,STATUS,SERVER
   FROM V$SESSION
   ORDER BY sid;