Skip to Main Content

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 CKPT - how it happens

ZerandibMar 29 2011 — edited Mar 30 2011
Hello,
A checkpoint can occur in these situations:
- redo log switch
- after specfied interval
- time out
- by force

But, When checkpoint occurs will these things happens. Is these things correct according to my knowledge
---> Data Buffer to Datafiles (by DBWn) YES

---> Commit occurring? (redo log buffer to redo logs) NO

---> Log switch occurring? NO

---> Archiving rego logs? (By ARCn) NO

Soo, when checkpoint occurs only thing happens is writing dirty blocks from data-buffer to data-files.
It will Not happening commits/log witching/archiving due to checkpoint. Is it?

-----------------------------------
What are the occasions that commit can occurs?
Is it when the redo log buffer gets filled


What are the occasions that log switch can occurs?
after 3sec/ redo log file 1/3 full anyother?


Regards,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2011
Added on Mar 29 2011
5 comments
5,304 views