Wednesday, July 25, 2018

How to check Locked objects in oracle data base

Need to run below query to check locked objects.

SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name 
FROM V$Locked_Object A, All_Objects B
WHERE A.Object_ID = B.Object_ID;

No comments:

Post a Comment