Oracle锁表查询和处理(kill掉session)

查询是被那个sid锁住哪一张表

select object_name, machine, s.sid, s.serial#  FROM $locked_object l, dba_objects o, $session s  WHERE l.object_id = o.object_id  AND l.session_id = s.sid;

杀掉该连接

alter system kill session '405, 1619';