Which benefit does Oracle Fast COMMIT offer?
Minimal information is required to record the changes in the redo logs, due LRU is deferred. Writes to the datafiles are deferred to reduce disk contention and I/O. Oracle’s Fast COMMIT allows LGWR to record only the changes and SCN in the redo log files. The size of the transaction does not affect the time required to write to the redo log files. These writes are sequential and faster than writing entire blocks to the datafiles. Writes to the datafiles occur independently of the COMMIT.