[Resolvido] Gerenciamento de sessões.

[alphamek 2]

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