QUESTION POSED ON: 02 June 2008
I have been trying to understand the relationship between CKPT and commit process.
Please let me know the actions taken by LGWR, DBWN and CKPT and the final picture of SCN entry, RBA entry (both in control file and data file headers), datafile status and redo file status in the following scenarios:
1) User A has a transaction going on, he has not commited it. CKPT is fired.
2) User A has a transaction going on, he commits it.
3) User A has a transaction going on , he commits it and at the same time CKPT fires.
Even if you could give me the reference of some article which describes the interdependent operation of CKPT (Incremental) and commit, that may suffice.
|
