DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Operating System Block Size

  1. #1
    Join Date
    Sep 2000
    Posts
    96
    For a new database, I am trying to determine what the correct DB_BLOCK_SIZE should be. I know this should be based on what the operating system block size is set. In NT, how to I find out what the operating system block size is?

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You set the DB_BLOCK_SIZE not based on the OS primarily, it should be determind based on the type of application it is going to be used for OLTP 2K - 8K, DSS 8K- 32K. For a multipurpose one 8K would be appropriate.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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