Oracle Table Unlock

Web Search

--The first step is to view the locked tableSelect B.owner,b.object_name, B.object_id, L.session_id,l.locked_modeFromV$locked_object L, Dba_objects bwhere B.object_id=l.object_id;
--Step TwoSelect Do.OBJECT_ID, do.object_nameFrom Dba_objects doWhere do. OWNER=‘Istaudit‘and do.object_idIn (‘98565‘) ;
--Step ThreeSelectT2.username,t2.sid,t2.serial#,t2.logon_time, T2. Action,t1. Locked_modeFrom v$locked_object t1,v$session T2 where t1.session_id=t2.sid and object_id in ('  98565') order by T2.logon_time;
--The fourth step of the alter system kill session '137,11352';       

Oracle Table Unlock