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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#general-database-discussions
10 comments
7,260 views