Useful commands

To identify the locked table name and session id:


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


To Identify user domain information from windows: 

net user 183378 /domain