Oracle CHECKPOINT和REDO LOG

在线日志切换会触发CHECKPOINT操作。为了避免不必要的CHECKPOINT，配置合理的在线日志大小和组数就显得尤为重要。LGWR进程在写在线日志之前，要确保该在线日志所对应的脏块已经写入到数据文件中，当在线日志过小或者组数不够时，则容易导致LGWR进程写日志等待，从而导致性能问题。
以下警告日志表明在线日志切换过于频繁（3分钟左右切换一次），为了减少切换频率，建议增加在线日志文件大小：
Fri May 16 17:15:43 1997
Thread 1 advanced to log sequence 1272
Current log# 3 seq# 1272 mem# 0: /prod1/oradata/logs/redologs03.log
Thread 1 advanced to log sequence 1273
Current log# 1 seq# 1273 mem# 0: /prod1/oradata/logs/redologs01.log
Fri May 16 17:17:25 1997
Thread 1 advanced to log sequence 1274
Current log# 2 seq# 1274 mem# 0: /prod1/oradata/logs/redologs02.log
Thread 1 advanced to log sequence 1275
Current log# 3 seq# 1275 mem# 0: /prod1/oradata/logs/redologs03.log
Fri May 16 17:20:51 1997
Thread 1 advanced to log sequence 1276
Current log# 1 seq# 1276 mem# 0: /prod1/oradata/logs/redologs01.log
以下警告日志表明在线日志组数过少、在线日志过小或者DBWR进程写脏块速度过慢：
Thread 1 advanced to log sequence 248
Current log# 2 seq# 248 mem# 0: /prod1/oradata/logs/redologs02.log
Thread 1 cannot allocate new log, sequence 249
Checkpoint not complete
不得不提，当警告日志出现以上内容不一定表示数据库性能缓慢。如果数据库出现性能缓慢，则需要考虑调整日志文件大小和组数了。