Find Table Lock: Select * from v$Locked_Object A INNER JOIN All_Objects B ON A.object_ID = B.Object_ID Killed the Lock: Find session: Select * from v$session a inner join v$lock b on a.sid = b.sid where a.userName = '' alter system kill session 'sid, serial#'
