Well the question is, "does it matter whether you have to read 30 Oracle blocks or just one or two?". Regardless of the relationship between o/s blocks and Oracle blocks, Oracle is going to request that less o/s blocks be read if it only requires that a single Oracle block be read, right?
Originally posted by abhaysk
Well what if the smallest OS Blocks (.5K), which would mean 16 OS Blocks for a 8K Oracle Block, be split across N Disks?
Then do you still find any i/o reduction? -- Not neccessarly.
For this I would see no gain in ordering data by any field unless its a ordered structure.