13_Sessions.sql

13_Sessions.sql

set pagesize 200

set linesize 200

column username format a10

column MAQUINA format a25

column USR_SO format a10

column USR_DB format a13

column osuser format a10

column sid format 999999

column serial# format 9999999999

select b.username USR_DB,b.osuser USR_SO,b.machine MAQUINA ,b.SID,b.serial#,b.status,a.SPID SO_PROC, LOGON_TIME

  from v$process a,v$session b

  where a.ADDR = b.PADDR

  and b.username is not null

order by a.SPID

/