Skip to Main Content

Database Software

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!

Alignment of Physical Stripe Boundaries with Block Size Boundaries

LausMay 23 2013 — edited May 24 2013
Hi,
I was recently asked a simple question that I couldn't answare with certainty.
If your stripe depth is the same size as the database block, then a single I/O
issued by Oracle Database may result in two physical I/O operations. The question was: Why this MAY or MAY NOT happen?
I was thinking. Is there something (metadata or some header) in internal stripe structure, more precisely structure of ASM extent or AU, that require part of available space dedicated to database block data, or is it someting else?
Thx in advance for all answares.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 20 2013
Added on May 23 2013
1 comment
642 views