oracle表被锁定解决方法

1、找到对应表的 object_id

select y.* from v$locked_object t, dba_objects y where t.object_id = y.object_id

2、找到对应 object_id 的 session_id

select * from v$locked_object where object_id = '235081'

3、根据 session_id 对应的 sid 找到 serial#

select * from v$session where sid = '4225'

4、杀死对应的 session

-- alter system kill session 'sid, serial#'
alter system kill session '4225, 8575'