Buscar Bloqueos

select
  XIDSLOT, XIDSQN as order_me, oracle_username, 'ps -ef | grep ' || process process_finder,
  os_user_name,
  DECODE(locked_mode,
  		 1, 'SELECT',
		 2, 'SELECT FOR UPDATE / LOCK ROW SHARE',
		 3, 'INSERT/UPDATE/DELETE/LOCK ROW EXCLUSIVE',
		 4, 'CREATE INDEX/LOCK SHARE',
		 5, 'LOCK SHARE ROW EXCLUSIVE',
		 6, 'ALTER TABLE/DROP TABLE/DROP INDEX/TRUNCATE TABLE/LOCK EXCLUSIVE') lock_mode,
  object_name,
  object_type
from
  v$locked_object a,dba_objects b
where
  a.object_id = b.object_id
  order by order_me;