On-Line (CKPT INP)
数据库最近做查询时老是出现这种状态,前段时间增加了表空间和日志个数。请问出现这种状况可能的原因,以及该如何处理。谢谢
online.log当时的日志如下:
09:18:03 Logical Log 3591 Complete, timestamp: 0x612cdde8.
09:18:16 Logical Log 3592 Complete, timestamp: 0x612f5cf1.
09:18:34 Logical Log 3593 Complete, timestamp: 0x6131c6ce.
09:19:07 Logical Log 3594 Complete, timestamp: 0x61350fbe.
09:20:49 Checkpoint Completed: duration was 34 seconds.
09:20:49 Fri May 17 - loguniq 3595, logpos 0x14ac7e4, timestamp: 0x61a2bbc3 Interval: 95216
09:20:49 Maximum server connections 95
09:20:49 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 49, Llog used 37575
09:21:02 Logical Log 3595 Complete, timestamp: 0x61b1bbe3.
09:23:37 Logical Log 3596 Complete, timestamp: 0x61b86c5b.
09:23:52 Logical Log 3597 Complete, timestamp: 0x61bae4bd.
09:24:09 Logical Log 3598 Complete, timestamp: 0x61bd585f.
09:24:49 Logical Log 3599 Complete, timestamp: 0x61bfe7bf.
09:25:29 Logical Log 3600 Complete, timestamp: 0x61c28088.
09:25:55 Logical Log 3601 Complete, timestamp: 0x61c5510a.
09:26:11 Checkpoint Completed: duration was 52 seconds.
09:26:11 Fri May 17 - loguniq 3600, logpos 0x2019158, timestamp: 0x61c70d87 Interval: 95217
09:26:11 Maximum server connections 95
09:26:11 Checkpoint Statistics - Avg. Txn Block Time 0.122, # Txns blocked 2, Plog used 35005, Llog used 69379
09:26:20 Logical Log 3602 Complete, timestamp: 0x61c91d5e.
09:26:41 Logical Log 3603 Complete, timestamp: 0x61cccd7f.
09:29:00 Logical Log 3604 Complete, timestamp: 0x62c0c3e8.
09:29:38 Logical Log 3605 Complete, timestamp: 0x62c96e1b.
09:32:28 Checkpoint Completed: duration was 107 seconds.
09:32:28 Fri May 17 - loguniq 3606, logpos 0x14627e0, timestamp: 0x62ce07db Interval: 95218
09:32:28 Maximum server connections 95
09:32:28 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 38687, Llog used 57002
09:35:59 Checkpoint Completed: duration was 0 seconds.
09:35:59 Fri May 17 - loguniq 3606, logpos 0x14aa534, timestamp: 0x62ce17fc Interval: 95219
09:35:59 Maximum server connections 95
09:35:59 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 9, Llog used 71