查看数据库表的锁情况
select b.object_name ,a.os_user_name ,a.LOCKED_MODE from v$locked_object a ,all_objects b
where a.OBJECT_ID = b.object_id;
--找到销表object_name 是你操作的表的session_id
SELECT * FROM v$locked_object a ,user_objects b
WHERE a.OBJECT_ID = b.object_id;
--通过 sid找到sid,serial#
SELECT * FROM v$session WHERE sid = 236;
--alter system kill session 'sid,serial#'
ALTER SYSTEM KILL SESSION '236,17615';
select b.object_name ,a.os_user_name ,a.LOCKED_MODE from v$locked_object a ,all_objects b
where a.OBJECT_ID = b.object_id;
--找到销表object_name 是你操作的表的session_id
SELECT * FROM v$locked_object a ,user_objects b
WHERE a.OBJECT_ID = b.object_id;
--通过 sid找到sid,serial#
SELECT * FROM v$session WHERE sid = 236;
--alter system kill session 'sid,serial#'
ALTER SYSTEM KILL SESSION '236,17615';