Useful shortcuts for vi editor

Friday, 14 November 2014

What is Oracle doing when you run commit?

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