Re: Large block sizes for OLAP database

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: stmontgo@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 2 Feb 2009 20:19:45 +0000

If oracle recommend it then sooner or later you'll need to jump
through the hoops of reproducing the issue on a large block size db
with support on an sr!

On 2/2/09, stmontgo@xxxxxxxxx <stmontgo@xxxxxxxxx> 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?
>
> Thanks
>
> Steve
>
> Our config will look like this
> OEL 64 bit
> Oracle 10.2.0.4
> OBIEE 10.1.3.4
> OBI (Hr Analytics) 7.9.5.1
>

-- 
Sent from Google Mail for mobile | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l


Other related posts: