检查点是数据库正常关闭时确保所有已提交数据写入数据文件的过程，其频率与重做日志文件大小有关。频繁的全检查点可能导致数据库性能下降。CKPT进程负责写入重做信息到在线重做日志文件，而DBWn进程写入数据到数据文件。
65. Which two statements are true about checkpointing? (Choose two.)
A.The checkpoint frequency decreases with the smaller redo log file size.
B.It ensures that all committed data is written to the data files during normal shutdown.
C.The frequent full checkpoint in a database can cause the overall degradation of the database
performance.
D.It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the
online redo log files.
最低0.47元/天 解锁文章
扫一扫
531
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
