互联网服务数据库查询

On-Line (CKPT INP)

数据库最近做查询时老是出现这种状态,前段时间增加了表空间和日志个数。请问出现这种状况可能的原因,以及该如何处理。谢谢online.log当时的日志如下:09:18:03  Logical Log 3591 Complete, timestamp: 0x612cdde8.09:18:16  Logical Log 3592 Complete...显示全部
数据库最近做查询时老是出现这种状态,前段时间增加了表空间和日志个数。请问出现这种状况可能的原因,以及该如何处理。谢谢
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收起
参与9

查看其它 8 个回答zhou5526的回答

zhou5526zhou5526系统工程师PICC
检查从硬件入手看看
互联网服务 · 2013-05-27
浏览4606

回答者

zhou5526
系统工程师PICC

zhou5526 最近回答过的问题

回答状态

  • 发布时间:2013-05-27
  • 关注会员:0 人
  • 回答浏览:4606
  • X社区推广