医院图书馆网站建设的意义,什么是竞价推广,请问有没有做网站,window7 iis建立网站当前位置:我的异常网 Oracle技术 oracle被一堆insert和update堵死解决方案oracle被一堆insert和update堵死解决方案www.myexceptions.net 网友分享于#xff1a;2014-07-22 浏览#xff1a;0次oracle被一堆insert和update堵死在生产环境下#xff0c;几乎每天都会发生一次…当前位置:我的异常网» Oracle技术 » oracle被一堆insert和update堵死解决方案oracle被一堆insert和update堵死解决方案www.myexceptions.net 网友分享于2014-07-22 浏览0次oracle被一堆insert和update堵死在生产环境下几乎每天都会发生一次数据库被几百个insert和update堵死造成应用中间件死掉这个时候查看oracle是没有锁的所以肯定排除掉了死锁的可能性如下内容为数据库日志(有朋友说是redo过小造成的但放大到多少合适呢)Thu Jan 10 09:53:03 2013Thread 1 cannot allocate new log, sequence 5024Checkpoint not completeCurrent log# 1 seq# 5023 mem# 0: DATA/gx/onlinelog/group_1.667.802435761Current log# 1 seq# 5023 mem# 1: DATA/gx/onlinelog/group_1.647.802435765Thu Jan 10 09:53:46 2013Thread 1 advanced to log sequence 5024 (LGWR switch)Current log# 2 seq# 5024 mem# 0: DATA/gx/onlinelog/group_2.669.802435767Current log# 2 seq# 5024 mem# 1: DATA/gx/onlinelog/group_2.668.802435771Thu Jan 10 09:55:13 2013Thread 1 cannot allocate new log, sequence 5025Checkpoint not completeCurrent log# 2 seq# 5024 mem# 0: DATA/gx/onlinelog/group_2.669.802435767Current log# 2 seq# 5024 mem# 1: DATA/gx/onlinelog/group_2.668.802435771Thu Jan 10 09:55:51 2013AUD: Audit Commit Delay exceeded, written a copy to OS Audit TrailThu Jan 10 09:55:51 2013AUD: Audit Commit Delay exceeded, written a copy to OS Audit TrailThu Jan 10 09:55:52 2013Thread 1 advanced to log sequence 5025 (LGWR switch)Current log# 3 seq# 5025 mem# 0: DATA/gx/onlinelog/group_3.267.802435775Current log# 3 seq# 5025 mem# 1: DATA/gx/onlinelog/group_3.266.802435779Thu Jan 10 09:57:05 2013Thread 1 cannot allocate new log, sequence 5026Checkpoint not completeCurrent log# 3 seq# 5025 mem# 0: DATA/gx/onlinelog/group_3.267.802435775Current log# 3 seq# 5025 mem# 1: DATA/gx/onlinelog/group_3.266.802435779Thu Jan 10 09:57:46 2013Thread 1 advanced to log sequence 5026 (LGWR switch)Current log# 1 seq# 5026 mem# 0: DATA/gx/onlinelog/group_1.667.802435761Current log# 1 seq# 5026 mem# 1: DATA/gx/onlinelog/group_1.647.802435765Thu Jan 10 09:57:47 2013AUD: Audit Commit Delay exceeded, written a copy to OS Audit TrailThu Jan 10 09:59:01 2013Thread 1 cannot allocate new log, sequence 5027Checkpoint not completeCurrent log# 1 seq# 5026 mem# 0: DATA/gx/onlinelog/group_1.667.802435761Current log# 1 seq# 5026 mem# 1: DATA/gx/onlinelog/group_1.647.802435765Thu Jan 10 09:59:40 2013Thread 1 advanced to log sequence 5027 (LGWR switch)Current log# 2 seq# 5027 mem# 0: DATA/gx/onlinelog/group_2.669.802435767Current log# 2 seq# 5027 mem# 1: DATA/gx/onlinelog/group_2.668.802435771Thu Jan 10 10:00:53 2013Thread 1 cannot allocate new log, sequence 5028Checkpoint not completeCurrent log# 2 seq# 5027 mem# 0: DATA/gx/onlinelog/group_2.669.802435767Current log# 2 seq# 5027 mem# 1: DATA/gx/onlinelog/group_2.668.802435771Thu Jan 10 10:01:31 2013Thread 1 advanced to log sequence 5028 (LGWR switch)Current log# 3 seq# 5028 mem# 0: DATA/gx/onlinelog/group_3.267.802435775Current log# 3 seq# 5028 mem# 1: DATA/gx/onlinelog/group_3.266.802435779Thu Jan 10 10:02:51 2013Thread 1 cannot allocate new log, sequence 5029Checkpoint not completeCurrent log# 3 seq# 5028 mem# 0: DATA/gx/onlinelog/group_3.267.802435775Current log# 3 seq# 5028 mem# 1: DATA/gx/onlinelog/group_3.266.802435779Thu Jan 10 10:03:31 2013Thread 1 advanced to log sequence 5029 (LGWR switch)Current log# 1 seq# 5029 mem# 0: DATA/gx/onlinelog/group_1.667.802435761Current log# 1 seq# 5029 mem# 1: DATA/gx/onlinelog/group_1.647.802435765Thu Jan 10 10:04:54 2013Thread 1 cannot allocate new log, sequence 5030Checkpoint not completeCurrent log# 1 seq# 5029 mem# 0: DATA/gx/onlinelog/group_1.667.802435761Current log# 1 seq# 5029 mem# 1: DATA/gx/onlinelog/group_1.647.802435765文章评论
