Script - Activos

Con este script vemos las sesiones activas en la bbdd, (entornos no MTS).

SET LINESIZE 1000

SELECT V$SESSION.LOGON_TIME CONEXION,

SUBSTR(V$PROCESS.SPID,1,5) UNIX,

SUBSTR(TO_CHAR(V$SESSION.SID),1,3) SID,

SUBSTR(V$SESSION.USERNAME,1,10) USUARIO,

SUBSTR(TO_CHAR(V$SESSION.SERIAL#),1,6) NSERIE,

SUBSTR(V$SESSION.OSUSER,1,10) OSUSER,

SUBSTR(V$SESSION.STATUS,1,10) ESTADO,

SUBSTR(V$SESSION.SERVER,1,7) SERVER,

SUBSTR(V$SESSION.MACHINE,1,30) MAQUINA

FROM

V$SESSION,

V$PROCESS

WHERE

(V$SESSION.PADDR = V$PROCESS.ADDR) AND

(V$SESSION.USERNAME IS NOT NULL) AND

(V$SESSION.SERVER LIKE 'DEDIC%') AND

SUBSTR(V$SESSION.STATUS,1,10) LIKE 'ACTIV%'

ORDER BY V$PROCESS.SPID;

SET LINESIZE 1000