An incremental checkpoint is a type of thread checkpoint partly intended to avoid writing large numbers of blocks at online redo log switches. DBW checks at least every three seconds to determine whether it has work to do. When DBW writes dirty buffers, it advances the checkpoint position, causing CKPT to write the checkpoint position to the control file, but not to the data file headers.
Both A and B are incorrect. Answer is CD:
Incremental checkpoints
An incremental checkpoint is a type of thread checkpoint partly intended to avoid writing large numbers of blocks at online redo log switches. DBW checks at least every three seconds to determine whether it has work to do. When DBW writes dirty buffers, it advances the checkpoint position, causing CKPT to write the checkpoint position to the control file, but not to the data file headers.
https://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT1301
https://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT89045
An incremental checkpoint is a type of thread checkpoint partly intended to avoid writing large numbers of blocks at online redo log switches.
DBW checks at least every three seconds to determine whether it has work to do.
When DBW writes dirty buffers, it advances the checkpoint position, causing CKPT to write the checkpoint position to the control file, but not to the data file headers.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
luizyto
2 years, 1 month agoRay520
2 years, 9 months agobrg850
3 years, 2 months ago_gio_
3 years, 4 months agojackymak
2 years, 11 months agoClozoerie
3 years, 6 months agocweather328
4 years, 11 months ago