根据表名查询锁状态:
SELECT
o.object_name,
s.sid,
s.serial#
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
WHERE
o.object_name = 'YOUR_TABLE_NAME'; -- 替换为你的表名
解除表锁:
ALTER SYSTEM KILL SESSION 'sid,serial#';