Como ver las seciones de un RAC.

[Wilo]

Consulta para revisar las sessiones de un RAC.

set linesize 140
set pagesize 200
col instance format a8
col host format a4
col spid format a8
col username format a12
col osuser format a12
col program format a18
col machine format a7
col status format a8
col module format a18
col Hr-Conexion format a20
set serveroutput on
SELECT i.INSTANCE_NAME instance, i.HOST_NAME host, s.SID, s.serial#,
p.spid, s.username, s.osuser, s.machine, s.MODULE, s.status,
TO_CHAR(s.logon_time, 'YYYY-MM-DD HH24:MI:SS') "Hr-Conexion"
FROM gv$session s, gv$process p, gv$instance i
WHERE s.paddr = p.addr AND (s.inst_id = p.inst_id AND s.INST_ID =
i.INST_ID) AND s.serial# > 1
ORDER BY s.logon_time, s.machine;