Re: Large block sizes for OLAP database

From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 2 Feb 2009 16:40:23 -0800
Message-ID: <a9c093440902021640j5f028149q38aebe2d4082564c_at_mail.gmail.com>

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, <stmontgo_at_gmail.com> 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?

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

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