For my development instance I plan to use 8k.
BTW I am using 8.1.6 on Solaris 2.7.
But for production and QA systems it should have a higher block size, correct?
I know I really need to know the bandwidth of a query... but is there a recommended range?
Something like 16k to 32k?
I know it should be <= the stripe size of the actual disks (which is like 500k I think) ... and <= the stripe size of my RAID.
Any recommendations on the block size (and while you're at it, the stripe size of my RAID)?
Typical block size of DSS/DW are 8k or higher.
db_block_size : Check OS limitations
8K should be ok, but depends upon the IO size of transaction.
RAID stripe size: MAX IO limitation of OS and the number of Disks u plan to have in a filesystem .
Stripe size (per disk) : Mulitple of (db_block_size * db_mulitblock_read_count)
For a DSS/DW, I would recommend 32K block size.
Click Here to Expand Forum to Full Width