DB block size for DSS/DW
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DB block size for DSS/DW

  1. #1

    Red face

    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.

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Typical block size of DSS/DW are 8k or higher.

  3. #3
    Join Date
    Feb 2001
    Posts
    389
    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)

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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
  •  



Click Here to Expand Forum to Full Width