Hakki Al Saidi حقي الساعدي
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment