Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

You execute some DMLcommands, followed by a COMMITStatement Which option correctly
describes how the logwriter (LGWR) process takes part in the transaction commit?

You execute some DMLcommands, followed by a COMMITStatement Which option correctly
describes how the logwriter (LGWR) process takes part in the transaction commit?

A.
1. LGWR writes the commit record to disk.
2. LGWR writes all redo entries from Redo Log Buffer to disk.

B.
1. GWR writes only the transaction’s redo entries from Redo Log Buffer to disk.
2. LGWR writes the commit record to disk.

C.
1. LGWR puts the commit record to Redo Log Buffer.
2. IGWR writes all redo entries from Redo Log Buffer to disk.

D.
1. LGWR puts the commit record to Redo Log Buffer.
2. If the activity is high, LGWR waits three seconds for other transactions to commit.
3. LGWR writes all redo log entries from Redo Log Buffer to disk.

E.
1. LGWR puts the commit record to Redo Log Buffer.
2. LGWR signals the database writer (DBW) process to write dirty blocks to disk.
3. LGWR writes all redo entries from Redo Log Buffer to disk.



Leave a Reply 8

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


Poloux

Poloux

A: lgrw always copy to disk, no buffer.

S. K. DAS

S. K. DAS

A is right.

db

db

C

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.

Asraful Azim Al Khalil

Asraful Azim Al Khalil

C