Oracle lock table and unlock caused by the for update

The situation I encountered:

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

SELECT * from  table for  update

When the data in the table is modified, but no commit is turned off PL/SQL, and the next time you open it, you will be stuck.

First, the lock table

To view the lock table process SQL statement:

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.

Oracle lock table and unlock caused by the for update