[Resolvido] Gerenciamento de sessões.

Olá,

Script para gerenciamento de todas as sessões que estão conectadas ao banco de dados.

SET LINE 125SET PAGESIZE 1000COLUMN username FORMAT A15COLUMN machine FORMAT A25COLUMN logon_time FORMAT A20SELECT s.username AS Usuario, s.osuser AS Login_rede, s.sid as Sessao, s.serial# as Serial, p.spid as processo, s.lockwait, s.status as Status, s.module as Modulo, s.machine as Maquina, s.program as Programa, TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS DuracaoFROM v$session s, v$process pWHERE s.paddr = p.addrORDER BY s.username, s.osuser;

Abraços, http://forum.imasters.com.br/public/style_emoticons/default/kiss.gif