— FOR LOCKED OBJECTS
FROM V$LOCKED_OBJECT LO,DBA_OBJECTS DO
WHERE LO.OBJECT_ID = DO.OBJECT_ID;
— FOR LOCKED USERS
FROM V$LOCK L, V$SESSION S
WHERE L.SID = S.SID;
Query the “v$locked_object” table for additional information about what is locked. Join with the “dba_objects” table for name and type. The object name indicates what is locked and the username columns identify who has created the lock.