1. 查看是否锁表
select
se.sid
,se.serial#,
lo.oracle_username,
lo.os_user_name,
do.object_name,
lo.locked_mode
from v$locked_object lo, dba_objects do, v$session se, v$process pr
where do.object_id = lo.object_id
and lo.session_id = se.sid;
2. 解锁
alter system kill session '257,35079';
第一个参数是sid, 第二个是serial#