冬瓜茶饮料

NC 单据保存时间过长,判断数据库锁表解决办法

SELECT  s.sid, s.serial# 
FROM gv$locked_object l, dba_objects o, gv$session s 
WHERE l.object_id = o.object_id 
AND l.session_id = s.sid;

alter system kill session 'sid,serial';

 

posted on 2016-08-26 15:41  冬瓜茶饮料  阅读(781)  评论(0编辑  收藏  举报

导航