ON COMMIT, THE LOG WRITER FLUSHES THE LOG BUFFER TO DISK
8.
þ
C. On COMMIT, the log writer flushes the log buffer to disk. No other
background processes need do anything.
ý
A, B, and D. A is wrong because checkpoints only occur on request, or
on orderly shutdown. B is wrong because the algorithm DBWn uses to select
buffers to write to the datafiles is not related to COMMIT processing, but to
how busy the buffer is. D is wrong because ARCn only copies filled online
redo logs; it doesn’t copy change vectors in real time.