當前位置:我的異常網? 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?2013

Thread?1?cannot?allocate?new?log,?sequence?5024

Checkpoint?not?complete

Current?log#?1?seq#?5023?mem#?0:?+DATA/gx/onlinelog/group_1.667.802435761

Current?log#?1?seq#?5023?mem#?1:?+DATA/gx/onlinelog/group_1.647.802435765

Thu?Jan?10?09:53:46?2013

Thread?1?advanced?to?log?sequence?5024?(LGWR?switch)

Current?log#?2?seq#?5024?mem#?0:?+DATA/gx/onlinelog/group_2.669.802435767

Current?log#?2?seq#?5024?mem#?1:?+DATA/gx/onlinelog/group_2.668.802435771

Thu?Jan?10?09:55:13?2013

Thread?1?cannot?allocate?new?log,?sequence?5025

Checkpoint?not?complete

Current?log#?2?seq#?5024?mem#?0:?+DATA/gx/onlinelog/group_2.669.802435767

Current?log#?2?seq#?5024?mem#?1:?+DATA/gx/onlinelog/group_2.668.802435771

Thu?Jan?10?09:55:51?2013

AUD:?Audit?Commit?Delay?exceeded,?written?a?copy?to?OS?Audit?Trail

Thu?Jan?10?09:55:51?2013

AUD:?Audit?Commit?Delay?exceeded,?written?a?copy?to?OS?Audit?Trail

Thu?Jan?10?09:55:52?2013

Thread?1?advanced?to?log?sequence?5025?(LGWR?switch)

Current?log#?3?seq#?5025?mem#?0:?+DATA/gx/onlinelog/group_3.267.802435775

Current?log#?3?seq#?5025?mem#?1:?+DATA/gx/onlinelog/group_3.266.802435779

Thu?Jan?10?09:57:05?2013

Thread?1?cannot?allocate?new?log,?sequence?5026

Checkpoint?not?complete

Current?log#?3?seq#?5025?mem#?0:?+DATA/gx/onlinelog/group_3.267.802435775

Current?log#?3?seq#?5025?mem#?1:?+DATA/gx/onlinelog/group_3.266.802435779

Thu?Jan?10?09:57:46?2013

Thread?1?advanced?to?log?sequence?5026?(LGWR?switch)

Current?log#?1?seq#?5026?mem#?0:?+DATA/gx/onlinelog/group_1.667.802435761

Current?log#?1?seq#?5026?mem#?1:?+DATA/gx/onlinelog/group_1.647.802435765

Thu?Jan?10?09:57:47?2013

AUD:?Audit?Commit?Delay?exceeded,?written?a?copy?to?OS?Audit?Trail

Thu?Jan?10?09:59:01?2013

Thread?1?cannot?allocate?new?log,?sequence?5027

Checkpoint?not?complete

Current?log#?1?seq#?5026?mem#?0:?+DATA/gx/onlinelog/group_1.667.802435761

Current?log#?1?seq#?5026?mem#?1:?+DATA/gx/onlinelog/group_1.647.802435765

Thu?Jan?10?09:59:40?2013

Thread?1?advanced?to?log?sequence?5027?(LGWR?switch)

Current?log#?2?seq#?5027?mem#?0:?+DATA/gx/onlinelog/group_2.669.802435767

Current?log#?2?seq#?5027?mem#?1:?+DATA/gx/onlinelog/group_2.668.802435771

Thu?Jan?10?10:00:53?2013

Thread?1?cannot?allocate?new?log,?sequence?5028

Checkpoint?not?complete

Current?log#?2?seq#?5027?mem#?0:?+DATA/gx/onlinelog/group_2.669.802435767

Current?log#?2?seq#?5027?mem#?1:?+DATA/gx/onlinelog/group_2.668.802435771

Thu?Jan?10?10:01:31?2013

Thread?1?advanced?to?log?sequence?5028?(LGWR?switch)

Current?log#?3?seq#?5028?mem#?0:?+DATA/gx/onlinelog/group_3.267.802435775

Current?log#?3?seq#?5028?mem#?1:?+DATA/gx/onlinelog/group_3.266.802435779

Thu?Jan?10?10:02:51?2013

Thread?1?cannot?allocate?new?log,?sequence?5029

Checkpoint?not?complete

Current?log#?3?seq#?5028?mem#?0:?+DATA/gx/onlinelog/group_3.267.802435775

Current?log#?3?seq#?5028?mem#?1:?+DATA/gx/onlinelog/group_3.266.802435779

Thu?Jan?10?10:03:31?2013

Thread?1?advanced?to?log?sequence?5029?(LGWR?switch)

Current?log#?1?seq#?5029?mem#?0:?+DATA/gx/onlinelog/group_1.667.802435761

Current?log#?1?seq#?5029?mem#?1:?+DATA/gx/onlinelog/group_1.647.802435765

Thu?Jan?10?10:04:54?2013

Thread?1?cannot?allocate?new?log,?sequence?5030

Checkpoint?not?complete

Current?log#?1?seq#?5029?mem#?0:?+DATA/gx/onlinelog/group_1.667.802435761

Current?log#?1?seq#?5029?mem#?1:?+DATA/gx/onlinelog/group_1.647.802435765

文章評論