Oracle View lock table and unlock __oracle

View Lock Table

SELECT l.session_id Sid, S.serial#, L.locked_mode,l.oracle_username,


l.os_user_name,s.machine, S.terminal, O.object_name, s.logon_time from


v$locked_object l, all_objects o, v$session s


WHERE l.object_id = o.object_id　　and


l.session_id = S.sid


Order by Sid, S.serial#;

Unlock

This two SQL is performed under a user with DBA authority.

To make a remark, we should try not to use for update when we use PLSQL developer to modify the table. To modify the table, now the development is not a person, the same table may be several people in use, for update is a table-level lock, it is easy to lock the table, with rowID better, rowID is a row level and only locks the line you are currently working on.