Oracle - Get all locked Database Objects

Search Database SQL / Scripts

Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.

Submit SQL/Scripts

Database Queries/Scripts

Sample 1. Oracle - Get all locked Database Objects

SELECT allObj.Owner, allObj.Object_Name, locObj.Oracle_Username, locObj.OS_User_Name  

FROM V$Locked_Object locObj, All_Objects allObj

WHERE locObj.Object_ID = allObj.Object_ID

_{Like Feedback locked database objects Locked_Object All_Objects}