oracle 锁表解锁

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#