You execute some DMLcommands, followed by a COMMIT Statement.
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.