1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

SELECT
    l.session_id,
    l.locked_mode,
    l.oracle_username,
    l.os_user_name,
    o.object_name,
    s.sid,
    s.serial#,
    s.logon_time
FROM
    v$locked_object l,
    dba_objects o,
    v$session s
WHERE
    l.object_id = o.object_id
    AND l.session_id = s.sid;

ALTER SYSTEM KILL SESSION 'sid,serial#';