Query to find locks information in details | Oracle Databas

 

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

Post a Comment