NAV_BAR

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Friday, March 11, 2016

Identify the Locked objects in session

Query to get locked Object in Database.


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
/