Query to find locks information in details | Oracle Database
Query to find detailed information regarding Locks in Oracle Database
Below mentioned query will help you find the information regarding locks that what kind of lock it is, where it has occured, who is the owner of the object, object_id etc. The output is formatted according to PUTTY and CMD.
select a.session_id,a.oracle_username, a.os_user_name, b.owner "OBJECT OWNER", b.object_name,b.object_type,a.locked_mode from (select object_id, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, LOCKED_MODE from v$locked_object) a,(select object_id, owner, object_name,object_type from dba_objects) b where a.object_id=b.object_id