Monday, October 3, 2011

How to check if my table is locked??

select * from dba_waiters ; OR SELECT LPAD(' ',DECODE(l.xidusn,0,3,0)) || l.oracle_username "User Name",o.owner, o.object_name, o.object_type FROM v$locked_object l, dba_objects o WHERE l.object_id = o.object_id ORDER BY o.object_id, 1 desc ;

No comments: