Using this query you can find all locking session
SELECT SID FROM V$LOCK
WHERE ID1 IN (SELECT OBJECT_ID FROM DBA_OBJECTS
WHERE OWNER='RND'
AND OBJECT_NAME='DEPT');
SELECT SID FROM V$LOCK
WHERE ID1 IN (SELECT OBJECT_ID FROM DBA_OBJECTS
WHERE OWNER='RND'
AND OBJECT_NAME='DEPT');
No comments:
Post a Comment