On AIX, blocksize an DataWarehouses

From: Frank R. <trek1s_at_gmail.com>
Date: 21 Nov 2006 07:36:35 -0800
Message-ID: <1164123395.299731.210040@m73g2000cwd.googlegroups.com>

Hello everybody,

I'm currently involved in a Siebel Analytics/Datawarehouse deployment. The datawarehouse database (9.2.0.8 AIX 5.3) was originally created with a 8kb blocksize (standard) which as far as i've read anywhere or asked anyone, is quite small, reccommending 32kb instead.

Apart from a stripping strategy between several disks, blocksize seems critical in I/O improvement and I need advice on the relationship between oracle blocksize and AIX blocksize. ATM, the OS blocksize is 4kb but, what would be the perfect size for it ¿32k too? ¿any oracle blocksize multiple?

Thanks in advance for your help. Received on Tue Nov 21 2006 - 09:36:35 CST