Verificar usuário “lockado” no banco de dados Oracle
Script para identificar se algum usuário do banco de dados esta “lockando” algum objeto.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
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; |