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';
Written by jerry80409
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Oracle
Authors
Related Tags
#oracle
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#