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

Home -> Community -> Usenet -> c.d.o.misc -> Re: What blocksize?

Re: What blocksize?

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 17 Aug 1999 07:43:56 -0400
Message-ID: <37B94AFB.C37A464F@Unforgettable.com>


With any Oracle V7.3 or higher database there is actually a performance penalty for using 2048. In most cases 4096 works quite well, but I suspect that the O'Reilly book is correct in suggesting that 8192 is more appropriate for data warehousing.

Ken

kev wrote:

> Hi,
>
> I'm wondering what blocksize to use for a DB I'm creating. In the
> O'Reilly book they suggest:
>
> "- Choose a small blocksize (2048 or 4096) for transaction systems where
> there are frequent queries, inserts, and updates that involve a single
> row.
> - Choose large blocksize (8192 or larger) for data warehouses and other
> large DB application where most data is bulk loaded, there are few
> updates, and most queries return multiple rows or involve full table
> scans"
>
> I building a database driven website on Red Hat Linux 6, so neither of
> the above scenarios really fits my situation. The second one probably
> comes closer, so I'm thinking at the moment that 8192 would be
> preferable. I'd be interested to know what blocksize others have used
> for similar applications on the same platform.
>
> TIA
>
> - Kev
Received on Tue Aug 17 1999 - 06:43:56 CDT

Original text of this message

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