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#

 
 
 
 
