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@xxxxxxxx> 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@xxxxxxxxx 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

Other related posts: