暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

log file switch (checkpoint incomplete) event

原创 Anbob 2012-12-18
1500

From the AWR we can see what issue is more frequent:
a) DBWR has not finished checkpointing (log file switch (checkpoint incomplete) )
b) ARCH has not finished copying the redo log file to the archive destination (Archival required)
c) Wait event in session is log file switch (checkpoint incomplete).

The difference between log file switch completion and log file switch completion (Checkpoint Incomplete) wait event is, in the case of former wait event the users wait for the Log writer background process (LGWr) to complete its work (log switch). In the case of latter wait event the users wait for the Database Writer background process (DBWr) to complete its work (checkpoint).
Also be aware of the v$log_history view for showing the frequency of log switches.Redo log switching should occur approximately every 20-30 minutes to get better database performance.You should start with a minimum of 100 MB redo log files for any production database.

Brian Carr's Article
"
The log file switch - checkpoint incomplete event tells you that Oracle wants to reuse a redo log file, but the current checkpoint position is still in that log file. This results in redo generation being stopped until the log switch is done. Obviously not good!
Recommendation:
To resolve these incomplete checkpoints you need to give the checkpoint process more time to cycle through the logs by doing one or both of the following:
* increase the size of the redo logs
* add more redo log groups
Additionally, consider turning off logging for the temporary tables with transient data using the the NOLOGGING attribute on the tables.
"
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论