| << Back to previous view |
|
[QA-16] Does commit cause checkpoint ? Created: 15/Jul/07 Updated: 16/Sep/07 |
|
| Status: | Closed |
| Project: | Questions & Answers |
| Fix Version/s: | None |
| Type: | Oracle - Database Tuning | Priority: | Major |
| Reporter: | ubTools Support | Assignee: | ubTools Support |
| Resolution: | Answered | Votes: | 0 |
| Product Version: | Generic |
| Operating System: | Generic |
| Description |
|
Does commit cause checkpoint ?
|
| Comments |
| Comment by 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. |