Re: Instance Recovery
A commit will not return control (e.g. to the next instruction) until all the redo data for the transaction has been physically written to the redo log file(s) - the check point does NOT do that.
Originally posted by ramuganapathi
2. user is modifiying the data and issues commit.
3. changes gets logged into redo log file.
4. after some interval, chkpt occurs - the LGWR pushes the data from the redo buffer to redo data file.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman