eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 2008主流数据库产品回顾与展望 | Blog首页 | Oracle DataGuard 常用维护命令参考手册 »

Oracle Wait Events:checkpoint completed

今天帮用户恢复数据库,在关闭数据库时发现如下一个显著的等待事件:
WAIT #1: nam='checkpoint completed' ela= 4892320 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892538 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892539 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892555 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892541 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892546 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892549 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892495 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892542 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 4892535 p1=0 p2=0 p3=0
WAIT #1: nam='checkpoint completed' ela= 1429367 p1=0 p2=0 p3=0

数据库可能在这个事件上花费大量的等待时间,这个事件没有参数表达:
SQL> SELECT NAME, parameter1, parameter2, parameter3
  2    FROM v$event_name
  3  WHERE NAME = 'checkpoint completed';

NAME                PARAMETER1 PARAMETER2 PARAMETER3
-------------------- ---------- ---------- ----------
checkpoint completed

文档的解释如下:
checkpoint completed
A session waits for a checkpoint to complete.
This could happen, for example, during a close database or a local checkpoint.

Wait Time: 5 seconds
Parameters: None

也就是说,会话在等待检查点的完成,在数据库关闭、本地检查点发生时可能见到。


历史上的今天...
    >> 2011-03-03文章:
    >> 2008-03-03文章:
    >> 2006-03-03文章:
           又是一年三月三

无觅

By eygle on 2009-03-03 10:58 | Comments (4) | FAQ | 2212 |

4 Comments

然后呢?就没了?
你这文章写的 :(

同感. 打一棍子,吱一声.

同感. 打一棍子,吱一声.

我只是对"checkpoint completed"这个等待事件不感兴趣,所以没打一棍子. ^_^

这年头,还有多少人关心技术,测试一下,哈哈


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com