SET PAGESIZE 5000
SET LINESIZE 250
 
COLUMN logon_time FORMAT     A20
COLUMN username   FORMAT     A15
COLUMN osuser     FORMAT     A15
COLUMN sid        FORMAT   99999
COLUMN serial#    FORMAT 9999999
COLUMN wait_class FORMAT     A15
COLUMN state      FORMAT     A19
 
SELECT NVL(a.username, '(ORA-BACKGROUND)') AS USERNAME,
       a.osuser                            AS OS_USER,
       a.sid                               AS SID,
       a.serial#                           AS SERIAL,
       d.spid                              AS PROC_ID,
       a.wait_class                        AS WAIT_CLASS, 
       a.seconds_in_wait                   AS SECS_WAITED,
       a.state                             AS STATE,
       a.blocking_session                  AS BLOCKING,
       a.blocking_session_status           AS BLOCKING_STATUS,
       a.module                            AS MODULE,
       to_char (a.logon_Time,'DD.MM.YYYY HH24:MI:SS') 
                                           AS logon_time
FROM   v$session a,
       v$process d
WHERE  a.paddr  = d.addr
AND    a.STATUS = 'ACTIVE'
ORDER BY 1,2;