Re: Oracle on AIX (Block Size)

If you are running on AIX file systems, you should not go higher than 4K. The reason is that anything larger will force 2 concurrent AIX filesystem blocks to be read and could force AIX to perform a read-ahead. This could return more than 128k per Oracle read and could flood your file system cache.

If you are on raw, there should not be a problem with higher block sizes.

Hank

Earl Shaffer <mmkprod_at_email.msn.com> wrote in article <efk4vwkP9GA.226_at_upnetnews04>...
> In my previous shop we used 4K and had good results with 7.1 and AIX
 3.2.5.
> 2K is often used for DSS and 8K for batch and data w. apps.
>
> Ian wrote in message <01bd3c94$89871680$8ae2020a_at_RELAY32.rogers.com>...
> >I would like to know what block size people are using on AIX.
> >
> >Oracle recommends 4K, but I would like to run higher. Please let me
 know
> >how your implemenation looks.
> >
> >Thanks,
> >
> >Ian Abramson
>
>
>
Received on Tue Feb 24 1998 - 00:00:00 CST