Re: On AIX, blocksize an DataWarehouses

Frank R. wrote:
> 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.

http://www.dizwell.com/prod/node/58

> 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.

Based on what metric(s) are you concluding that block size has any relationship to any performance issues you are trying to correct? If you don't have numbers that support the conclusion you are most likely going in the wrong direction.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org