查询
SELECT
o.object_name,
s.sid,
s.serial#,
p.spid,
s.username,
s.program
FROM
v$locked_object l
JOIN dba_objects o ON l.object_id = o.object_id
JOIN v$session s ON l.session_id = s.sid
LEFT JOIN v$process p ON p.addr = s.paddr;
解锁
ALTER SYSTEM KILL SESSION 'sid,serial#';