List All Active Sessions in Oracle 11g

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;