oracle库表被锁问题

1、查询被锁的表（object_name）以及是哪个session引起的

select a.OS_USER_NAME, c.owner, c.object_name, b.sid, b.serial#, logon_time
from v$locked_object a, v$session b, dba_objects c
where a.session_id = b.sid
and a.object_id = c.object_id
order by b.logon_time desc;

2、杀掉对应进程即可
alter system kill session 'sid, serial#';