The server process modifies the table data the sga

8. When the transaction is committed, the LGWR process immediately records the transaction in the redo log file.

9. The DBWn process writes modified blocks to the disk when doing so is efficient.

• Archive log files: Contain an ongoing history of the data changes (redo) that are generated by the instance. Using these files and a backup of the database, you can recover a lost data file. That is, archive logs enable the recovery of restored data files.

Oracle Database 10g: Administration Workshop II 1-14

Over 10 Million Study Resources Now at Your Fingertips