Monitoração de Objetos em LOCK

Olá,

Esse script mostra ao DBA todos os objetos do banco de dados que estão em LOCK e qual o tipo de lock.

SET LINESIZE 500SET PAGESIZE 1000SET VERIFY OFFCOLUMN owner FORMAT A20COLUMN username FORMAT A20COLUMN object_owner FORMAT A20COLUMN object_name FORMAT A30COLUMN locked_mode FORMAT A15SELECT b.session_id AS sid, NVL(b.oracle_username, '(oracle)') AS username, a.owner AS object_owner, a.object_name, Decode(b.locked_mode, 0, 'None', 1, 'Null (NULL)', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share (S)', 5, 'S/Row-X (SSX)', 6, 'Exclusive (X)', b.locked_mode) locked_mode, b.os_user_nameFROM dba_objects a, v$locked_object bWHERE a.object_id = b.object_idORDER BY 1, 2, 3, 4;SET PAGESIZE 14SET VERIFY ON

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