nerdexam
Oracle

1Z0-062 · Question #146

Which statement is true about the Log Writer process?

The correct answer is D. It writes when a user commits a transaction. The Log Writer process (LGWR) writes redo log buffer contents to the online redo log files primarily when a user commits a transaction, guaranteeing that committed changes are durable before the commit acknowledgment is returned.

Exploring the Oracle Database Architecture

Question

Which statement is true about the Log Writer process?

Options

  • AIt writes when it receives a signal from the checkpoint process (CKPT).
  • BIt writes concurrently to all members of multiplexed redo log groups.
  • CIt writes after the Database Writer process writes dirty buffers to disk.
  • DIt writes when a user commits a transaction.

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    6% (2)
  • D
    91% (29)

Why each option

The Log Writer process (LGWR) writes redo log buffer contents to the online redo log files primarily when a user commits a transaction, guaranteeing that committed changes are durable before the commit acknowledgment is returned.

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

The checkpoint process (CKPT) signals the Database Writer process (DBWn) to write dirty buffers to data files; CKPT does not signal LGWR - LGWR has its own independent write triggers.

BIt writes concurrently to all members of multiplexed redo log groups.

LGWR writes only to the members of the currently active redo log group, not to all redo log groups at once; other groups are inactive and receive no writes until a log switch occurs.

CIt writes after the Database Writer process writes dirty buffers to disk.

The relationship is inverted - Oracle's write-ahead logging protocol requires LGWR to write redo information before DBWn can write dirty buffers to disk, ensuring that redo records are available for recovery of any data file writes.

DIt writes when a user commits a transaction.Correct

When a transaction issues a COMMIT, LGWR is triggered to flush the redo log buffer to the online redo log files before the commit is confirmed to the user. This write-ahead logging behavior ensures that any committed transaction can be recovered even if a subsequent failure occurs, which is the core purpose of LGWR.

Concept tested: Log Writer process LGWR write triggers and write-ahead logging

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/process-architecture.html

Topics

#LGWR#redo log buffer#transaction commit#background processes

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice