This preview shows page 1. Sign up to view the full content.
Unformatted text preview: the dirty blocks in the database buffer cache to disk.
Answer: C, E
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.
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
D: Oracle copies the online redo log files to the archive destinations regardless a
Oracle 8, DBA Certi...
View Full Document
- Fall '09