Alex Felipe Barbosa - Página 3 de 3 - Blog de Programação de Banco de Dados

Verificar usuário “lockado” no banco de dados Oracle

10 de março de 201617 de março de 2016 alexbarbosa 0 comentários lock, sql

Script para identificar se algum usuário do banco de dados esta “lockando” algum objeto.

SELECT c.username AS usuario_bd
      ,c.osuser AS usuario_so
      ,decode(b.id2, 0, a.object_name, 'Trans-' || to_char(b.id1)) AS objeto_bd
      ,a.object_type AS tipo_objeto
      ,c.machine AS maquina
      ,c.logon_time AS inicio_conexao
      ,c.program AS programa
  FROM dba_objects a
      ,v$lock      b
      ,v$session   c
 WHERE (a.object_id(+) = b.id1 AND b.sid = c.sid AND c.username IS NOT NULL)
 ORDER BY b.sid
         ,b.id2;

SELECT c.username AS usuario_bd

,c.osuser AS usuario_so

,decode(b.id2, 0, a.object_name, 'Trans-' || to_char(b.id1)) AS objeto_bd

,a.object_type AS tipo_objeto

,c.machine AS maquina

,c.logon_time AS inicio_conexao

,c.program AS programa

FROM dba_objects a

,v$lock b

,v$session c

WHERE (a.object_id(+) = b.id1 AND b.sid = c.sid AND c.username IS NOT NULL)

ORDER BY b.sid

,b.id2;

Ler mais