The basic flow like that;
- Oracle writes that "Commit has been executed" in related table from UNDO tablespace.
- SGA buffer cache - calling LGWR (Log Writer)
- LGWR writes changed data (delta) to REDO log files
- Tables' locks are released and marked as "TRANSACTION is completed" by Oracle