Oracle 查詢Table Lock 及刪除Lock Session

查詢Lock Session

SELECT
    s.sid,
    s.serial#,
    s.username,
    s.machine,
    s.program,
   -- l.type,
   -- l.lmode,
   -- l.request,
    o.object_name,
    o.object_type
FROM
    v$session s
    JOIN v$locked_object l ON s.sid = l.session_id
    JOIN dba_objects o ON l.object_id = o.object_id;

kill lock session

--ALTER SYSTEM KILL SESSION 'sid,serial#';
ALTER SYSTEM KILL SESSION '516,16217';