oracle 解锁

1.表级解锁：select 'alter system kill session ',''''||trim(t2.sid)||','||trim(t2.serial#)||''';'
from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time

执行查询的语句

2.用户解锁

ALTER USER username ACCOUNT UNLOCK;