E oracle flushes the dirty blocks in the database

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the dirty blocks in the database buffer cache to disk. Answer: C, E Explanation: Oracle performs a delayed block clean out and flushes the dirty blocks in he database buffer cache to disk during a checkpoint. A checkpoint is when Oracle writes all dirty buffers in the buffer cache to disk. Behind the scenes, Oracle's CKRT process marks the datafile header as current, and records the sequence number for the current checkpoint in the control file(s). Checkpoints are used to ensure that, at some point, all of the information in both the buffer cache is copied to disk, which synchronizes write activities performed by LGWR and DBWR. Incorrect Answers: A: A checkpoint will occur at least as often as a log switch, but can occur more frequently, depending on several factors. Actualtests.com - The Power of Knowing 1Z0-025 B: Oracle does not perform a control file. Control file is used to mount and open database. D: Oracle copies the online redo log files to the archive destinations regardless a checkpoint. Oracle 8, DBA Certi...
View Full Document

Ask a homework question - tutors are online