Re: DB_BLOCK_SIZE/RAID 5 for DEC ALPHA NT 4.0

We do run under NT, but when we converted our 2K block Oracle db under VMS to 4k there was a definite, noticeable improvement. In general larger blocksizes will result in performance gains for sequential processes like imp, exp, and full table scans. Most random I/O is generally unaffected by the change though index range scans improve due to their being more data in each leaf block.

About a year ago my partner along with an Oracle consultant installed Oracle on NT and he told me that on NT the largest Oracle block size was 4K. This may have changed, but you may want to check on this. Otherwise many Warehousing experts recommend using the larger blocksizes like 16k and 32k which Oracle supports on some platforms.

Sanjay Hans <sanhans_at_mbox5.singnet.com.sg> wrote in article <01be08ca$6ee0e100$80cb15a5_at_oempre-install>...
> I am planning to install Oracle 8.0 on Digital Alpha NT 4.0 Server. The
> Database will be for Datawarehousing. I am not sure whether DB_BLOCK_SIZE
> should be set to 4K or 8K while installing Oracle. What are
> advantages/disadvantages of 4K/8K?
>
> Do you have any experience of RAID 5 (Hardware configuration) on DEC
Alpha
> NT 4.0 running Oracle 8.0. Would appreciate your suggestions on it.
>
> Thanks in advance.
>
>
Received on Thu Nov 05 1998 - 12:58:21 CST