Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

checkpoint and commit

596582Jan 2 2008 — edited Jan 9 2008
Does commit causes checkpoint?If not so how committed data will be written immediately to data file and available to other user?
According to Oracle document Committed data will be saved in datafile and updated with latest SCN in datafile header files on checkpoint.Checkpoint will generate only for the fallowing condition,
1.logswitch
2.log_checkpoint_interval and time
So Data will not be saved immediately to datafile with latset SCN.My doubt is How other user will be able to get latset infomation immediately if logswitch and interval time takes long time.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2008
Added on Jan 2 2008
#general-database-discussions
31 comments
3,315 views