Re: Large block sizes for OLAP database
Date: Mon, 2 Feb 2009 16:40:23 -0800
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
> 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-lReceived on Mon Feb 02 2009 - 18:40:23 CST