Re: Large block sizes for OLAP database

From: Greg Rahn <>
Date: Mon, 2 Feb 2009 16:40:23 -0800
Message-ID: <>

I worked on a project that had a 17TB (compressed) partitioned table and 32TB of temp space using an 8k block. This was a straight forward dimensional model and there were not any tables with extremely long rows (none that exceeded an 8k block).

I guess it depends on what "OLAP type" means in terms of implementation.

Personally I see little value in different block sizes (I use 8k). There are numerous other design decisions that have far more performance impact.

On Mon, Feb 2, 2009 at 11:36 AM, <> wrote:
> Good day,
> We're jumping into the wonderfull world of Oracle Business Intelligence with
> HR Analytics.
> It looks like we'll be creating an OLAP type of database where Oracle
> recommends
> large block sizes. The database will also contain some metadata for the
> Informatica Configuration
> and HR Analytics portion.
> If I'm looking at larger block sizes and am wondering if I should be
> creating the database with
> a large block size or should I be looking at creating tablespaces with
> larger block sizes
> and leaving the db with a standard 8k size.
> Does anyone have an opion either way?

Greg Rahn
Received on Mon Feb 02 2009 - 18:40:23 CST

Original text of this message