ORACLE LOCKS

utworzone przez | gru 15, 2009 | Oracle

find locks:

select 
  oracle_username
  os_user_name,
  locked_mode,
  object_name,
  object_type
from 
  v$locked_object a,dba_objects b
where 
  a.object_id = b.object_id 
 
select l1.sid, ' BLOCK ', l2.sid from v$lock l1, v$lock l2
  where l1.block =1 and l2.request > 0
  and l1.id1=l2.id1
  and l1.id2=l2.id2;