Re: Oracle on AIX (Block Size)

Be careful here.

Block size is, of course, related to the type of application you are running and how that application is implemented (esp. it's 'locality of reference' to it's data, it's use of large and numerous sequential reads, raw v file system devices, etc.)

I'd agree that 'in general terms' 2K is a little on the low side and 4K is pretty reasonable. However we use 8K for datawarehouses and find that much better for those types of applications.

At the end of the day, testing with real-world data and real-world usage patterns will be the only sure way of achieving an optimal block size for your database and it's associated application(s).

Steve Phelan.

Earl Shaffer wrote in message ...
>I have been having problems posting, sorry
>
>I used 4K on AIX. I think it is a good middleground. I think 2k is too
>small and 8K is too big. We had good performance and I always found it to
>be easy to manage.
>
>
Received on Wed Feb 25 1998 - 00:00:00 CST