Re: best db block size

Hi

I have two views on this.

The first is that nearly all applications will not have application performance noticeably affected by the choice of block size. So I don't really care that much and tend to leave everything at the default. In general it's SQL and application design that will be your problem.

The second is that we could only give a recommendation if we knew what filesystem if any you were using and any special characteristics of the application as they pertain to block size (use of longs/blobs/clobs, rapidly expanding rows, lots of small lookup tables) and so on.

cheers

On 2/28/07, Denham Eva <DEVA_at_mf.co.za> wrote:
>
> This email is subject to Terms and Conditions as found in our Email Legal
> Notice which forms part of this email message in terms of section 11 of the
> Electronic Communications and Transaction Act 25 of 2002. Please click
> on http://www.mf.co.za/content/EMAIL_Legal_Notice.asp , or send a blank
> email to disclaim_at_mf.co.za. By receiving, reading or acting upon this
> email you will automatically be bound by the terms of the Email Legal
> Notice.
>
> Mutual & Federal Insurance Company Limited
>
> Authorised Financial Services Provider
>
>
>
> ------------------------------
>
> Hello
>
> we will be migrating to a AIX P5, we now have to decide on the db block
> size.
> I believe sticking with 8192.
> Is there any recommended size?
>
> Regards
> denham
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l