Here is a query with which you can see all of the active sessions on an Oracle database:
SELECT SID, Serial#, UserName, Status, SchemaName, Logon_Time
FROM V$Session
WHERE
Status=’ACTIVE’ AND
UserName IS NOT NULL;→ Continue reading “List All Active Sessions in Oracle 11g”