Reason for Oracle table lock and how to unlock it

The biggest possible cause is that the database locks the table if the changed data is not committed! Therefore, do not use a select * fromaforupdate statement when updating.

The biggest possible cause is that the database locks the table if the changed data is not committed! Therefore, do not use statements such as select * from a for update when updating.

The biggest possible cause is that the database locks the table if the changed data is not committed! Therefore, when updating a table, do not use statements such as select * from a for update to easily lock the table. select *, t. rowid from t is a statement that is recommended by the database.

Unlock method:

1. view the lock table process:

SQL: select * from v $ session t1, v $ locked_object t2 where t1.sid = t2.SESSION _ ID;

2. Kill the locked Process

SQL: alter system kill session SID, serial #;