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?
Printable View
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?
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