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#