Oracle lock table, unlock

The situation I encountered:

When querying a table with a SELECT statement, followed by for update,

Select  from  Table for   update

When you modify the data in the table, but do not have a commit to turn off PL/SQL, the next time to open the execution of the above statement, will be stuck, no more for update

First, the lock table

To view the lock table process SQL statement:

Select  from where

If there is a record, you can find the following lock table record

Second, unlock

Kill the Lock table process:
Record the SID and Serial#, replace the 1155,39095 below, and then unlock the table.

' 1155,39095 '

Oracle lock table, unlock