1Z0-052 · Question #111
Which two statements are true about checkpointing? (Choose two.)
The correct answer is 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. Checkpoints guarantee committed data is flushed to data files on normal shutdown, but excessive full checkpoints create heavy I/O overhead that degrades performance.
Question
Which two statements are true about checkpointing? (Choose two.)
Options
- AThe checkpoint frequency decreases with the smaller redo log file size.
- BIt ensures that all committed data is written to the data files during normal shutdown.
- CThe frequent full checkpoint in a database can cause the overall degradation of the database performance.
- DIt prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the
How the community answered
(46 responses)- A4% (2)
- B93% (43)
- D2% (1)
Why each option
Checkpoints guarantee committed data is flushed to data files on normal shutdown, but excessive full checkpoints create heavy I/O overhead that degrades performance.
Checkpoint frequency INCREASES with smaller redo log files because each log switch triggers an incremental checkpoint, so smaller logs cause more frequent log switches and thus more frequent checkpoints.
During a normal (clean) shutdown, Oracle performs a full checkpoint that directs the Database Writer (DBWn) to flush all dirty buffers from the buffer cache to the data files, ensuring all committed transactions are persisted and the database is in a consistent state.
A full checkpoint forces DBWn to write every dirty block in the buffer cache to disk simultaneously, generating a large spike in I/O; when full checkpoints occur too frequently, this sustained high I/O load reduces overall database throughput.
The CKPT process updates the control file and data file headers with checkpoint information, but it is the DBWn (Database Writer) background process that physically writes dirty data blocks to the data files.
Concept tested: Oracle checkpoint process behavior and performance impact
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/oracle-database-instance.html#GUID-C3B9B7F8-B7C4-4D3E-9B4F-8B1E2F5F8B1E
Topics
Community Discussion
No community discussion yet for this question.