Last Updated: November 08, 2019
·
122
· jerry80409

Oracle release table lock

List current schema table lock.
SELECT t1.LOCKED_MODE, t2.USERNAME, t2.SID, t2.SERIAL#, t3.OBJECT_NAME, t2.OSUSER, t2.MACHINE, t2.PROGRAM, t2.LOGON_TIME, t2.COMMAND, t2.LOCKWAIT, t2.SADDR, t2.PADDR, t2.TADDR, t2.SQL_ADDRESS FROM v$locked_object t1, v$session t2, dba_objects t3 WHERE t1.session_id = t2.sid AND t1.object_id = t3.object_id ORDER BY t2.logon_time;

Kill lock session
ALTER SYSTEM KILL SESSION 'SID';