title: Unlock An Oracle Table
body: <p>What are the different techniques for Unlocking an oracle table?</p>
  <p>What I Tried.</p>
  <ol>
  <li><p>Get the object ID of the locked table:</p>
  <blockquote>
  <p>SELECT object_id FROM dba_objects WHERE object_name='YOUR TABLE NAME';</p>
  </blockquote>
  </li>
  <li><p>Get the SID values for this ID:</p>
  <blockquote>
  <p>SELECT sid FROM v$lock WHERE id1=OBJECT ID FROM STEP1</p>
  </blockquote>
  </li>
  <li><p>Get the session values for these SIDs:</p>
  <blockquote>
  <p>SELECT sid, serial# from v$session where sid in (COMMA SEPARATED LIST OF SIDs FROM STEP2.)</p>
  </blockquote>
  </li>
  <li><p>Kill the sessions causing the lock:</p>
  <blockquote>
  <p>ALTER SYSTEM KILL SESSION (SID,SERIAL#)</p>
  </blockquote>
  </li>
  </ol>
  <p>pair values from step 3
  e.g. <code>ALTER SYSTEM KILL SESSION '231,23454'</code></p>
  <p>But The Problem is I have lot of tables which has been locked is there any other technique for unlocking the tables.</p>
  <p>I am using SQLDeveloper Is there any direct option for unlocking it.</p>