-
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)?
thanks.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|