Commit doesn't cause a checkpoint itself. If it was so, there would not be a need for redo-logging.
There is an article of K Gopalakrishnan. It's published in Oracle Internals magazine. Gopal explains the relationship and differences between commit-SCN and SCN.
ubTools Support - 15/Jul/07 02:34 PM Commit doesn't cause a checkpoint itself. If it was so, there would not be a need for redo-logging.
There is an article of K Gopalakrishnan. It's published in Oracle Internals magazine. Gopal explains the relationship and differences between commit-SCN and SCN.
Oracle - Database Tuning
Closed
Major
Does commit cause checkpoint ?
There is an article of K Gopalakrishnan. It's published in Oracle Internals magazine. Gopal explains the relationship and differences between commit-SCN and SCN.