Oracle DBA Day to Day Scripts: Active session information

Sunday, February 10, 2013

    SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time
    FROM V$Session
    WHERE
    Status='ACTIVE' AND
    UserName IS NOT NULL;