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