Oracle view lock table and unlock table ____oracle

in development, we may have deadlocks when manipulating the database, and if we don't want to wait, this requires us to manually kill the process.

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#;

Oracle Unlock Table

ALTER System KILL Session ' sid,serial# ';

Note: The SID in the Unlock table SQL refers to the sid;serial# in the above Query lock table.