Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

how oracle prevent "partial write"

649748Jun 13 2010 — edited Jun 15 2010
mysql innodb use "Double Write" to prevent partial write.
http://www.mysqlperformanceblog.com/2006/08/04/innodb-double-write/

But oracle doesn't have "Double Write", so what's the mechanism in oracle to prevent partial write?

We are planning to use 32k block size, and the file system level the block size is 8k. So if oracle writes 32k, but only the first blocks wrote to disk before crash, how oracle recover?
This post has been answered by HJR on Jun 15 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2010
Added on Jun 13 2010
10 comments
6,730 views