SQL Query to Display information on all active database sessions - Oracle Database

Displays information on all active database sessions in Oracle Database

The below mentioned script displays information regarding all active database sessions inside your Oracle database:

SET LINESIZE 500

SET PAGESIZE 1000

COLUMN username FORMAT A15

COLUMN machine FORMAT A25

COLUMN logon_time FORMAT A20

SELECT NVL(s.username, '(oracle)') AS username,

       s.osuser,

       s.sid,

       s.serial#,

       p.spid,

       s.lockwait,

       s.status,

       s.module,

       s.machine,

       s.program,

       TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time,

       s.last_call_et AS last_call_et_secs

FROM   v$session s,

       v$process p

WHERE  s.paddr  = p.addr

AND    s.status = 'ACTIVE'

ORDER BY s.username, s.osuser;