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;
Full-Stack software architect/engineer (currently working in the Big Data space), drummer, motorcyclist, and artist.
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;