Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: best db block size

Re: best db block size

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Wed, 28 Feb 2007 13:54:18 +0300
Message-ID: <97b7fd2f0702280254j4619c146w2d13c5ae79e709f@mail.gmail.com>


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-l
Received on Wed Feb 28 2007 - 04:54:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US