Re: db_block_size and performance

From: <grakaska_at_indy.wrep.com>
Date: Wed, 04 Nov 1998 19:09:22 GMT
Message-ID: <3640a3c6.17819533@netnews.msn.com>

On Wed, 04 Nov 1998 15:15:22 GMT, chuckh_at_safeaccess.net (Chuck Hamilton) wrote:

>On Tue, 03 Nov 1998 22:36:53 GMT, swpatter_at_wwa.com (Scott Patterson)
>wrote:
>
>>What would be the OS blosck size for Windows NT 4.0 sp3?
>>
>
>That would be whatever block size the OS uses to store it's files. I'm
>not sure what sp3 means. I'm more familiar with Unix than NT.

Go to a command prompt and run chkdsk and read the "xxxx bytes in each allocation unit" line, this is the block size. 512 is the default, but it can be formatted to larger sizes. I just set up my system this week and formatted the data drives to 8192 bytes per allocation unit and set the Oracle block size to 8192.

There may be another way to get the NT block size, I am a newbie to NT. We are in the process of switching from HP9000/HPUX to Compaq/NT. Received on Wed Nov 04 1998 - 13:09:22 CST