Oracle释放被锁的表

查看被锁的表ct

select b.owner, b.object_name, a.session_id, a.locked_mode
from v$locked_object a, dba_objects b where b.OBJECT_ID = a.OBJECT_ID

查看连接的进程

select sid, serial#, username, osuser from v$session;

杀掉进程 sid, serial#

alter system kill session '678,983';