Exam 1z0-062 All QuestionsBrowse all questions from this exam
Question 8

Which statement is true about the Log Writer process?

    Correct Answer: D

    The Log Writer (LGWR) process in Oracle Database writes redo log entries to the online redo log files. One of the primary situations that trigger this write is when a user commits a transaction. When a commit is issued, LGWR ensures that the corresponding redo entries are written to disk immediately to guarantee transactional integrity. This mechanism helps to ensure the durability of committed transactions, making option D the correct statement.

Discussion
hggzOption: D

The LGWR process writes redo information from the redo log buffer to the online redo log files under a variety of circumstances: ■ When a user commits a transaction, even if this is the only transaction in the log buffer. ■ When the redo log buffer becomes one-third full. ■ When the buffer contains approximately 1MB of changed records. This total does not include deleted or inserted records. ■ When a database checkpoint is performed. ■ When 3 seconds have elapsed since the last redo log buffer write.

nabhan2001nabhan

not ckeckpoint .

Nickhodges94

I believe both B and D are true. The LGWR background process does write to disk upon COMMIT: "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." However, It also writes simultaneously to all multiplexed redo log files: "LGWR writes synchronously to the active mirrored group of redo log files." Reference : https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm#i7261

hggz

D is correct, B - no. It writes concurrently to all multiplexed redo log groups, but not to all members in each group.

nabhan2001nabhanOption: D

When a user process commits a transaction – When an online redo log switch occurs – When the redo log buffer is one-third full or contains 1 MB of buffered data – Before a DBWn process writes modified buffers to disk

_Cobra_Option: D

only D is correct