Which statement is true about the Log Writer process?

Which statement is true about the Log Writer process?

Which statement is true about the Log Writer process?

A.
It writes when it receives a signal from the checkpoint process (CKPT).

B.
It writes concurrently to all members of multiplexed redo log groups.

C.
It writes after the Database Writer process writes dirty buffers to disk.

D.
It writes when a user commits a transaction.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Miriam

Miriam

D
When a user issues a COMMIT statement, LGWR puts a commit record in the redo log buffer and writes it to disk immediately, along with the transaction’s redo entries. The corresponding changes to data blocks are deferred until it is more efficient to write them. This is called a fast commit mechanism

Voeurng Sovann

Voeurng Sovann

Yes, agree answer is D

Peter

Peter

Why not B as well ?