Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: best db block size
You miss to give us the valid information, like, what application it would
be? Is it OLTP or Dataearehouse / DSS?
If OLTP, most probably 8k is good.
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
>
-- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 28 2007 - 04:54:18 CST
![]() |
![]() |