Re: DB_BLOCK_SIZE/RAID 5 for DEC ALPHA NT 4.0

Depending the nature of your application and/or the usage of the Oracle tables, increasing the block size may or may not hurt your performance. A general rule I follow is, if you you're doing a lot transactional processing, I would keep the block size less or equal to 4K, because most of the time you'll be retrieving or updating one row at a time and a record usually take up more than 4K. For DSS system, I would recomend a high block size. Our Data Warehouse is set to 16K block size.

Minh

David Sisk wrote:

> Hi:
>
> ORACLE on NT does support 8K (and larger, I believe), and yes, you will
> probably get better performance with a larger block-size. Concerning RAID,
> check the URL below.
>
> Regards,
>
> --
> David C. Sisk
> http://www.ipass.net/~davesisk/ORACLEonNT.htm
>
> Sanjay Hans wrote in message <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 Wed Nov 11 1998 - 22:18:45 CST