DB_BLOCK_SIZE??? Survey.

From: Grabowy, Chris <chris.grabowy_at_lmco.com>
Date: Wed, 23 Jul 2003 10:16:19 -0400
Message-Id: <25998.339123@fatcity.com>

I just started at my new DBA job, and I have been reviewing their database installation procedure. I noticed that they create all their databases with a 4K block size. This is for Oracle 9.2 on AIX 5.2. It has been my general understanding that most sites these days use 8K db_block_size as a minumum for general OLTP databases. And some sites are considering 16K db block size tablespace for indexes.

At any rate, does anyone have any pro/con thoughts on the smaller 4K db block size???

Also, if your interested, please reply back to me DIRECTLY with your site's DB_BLOCK_SIZEs for OLTP/DWs. I promise to tally the results and share them with everyone.

mailto:chris.grabowy_at_lmco.com

Many thanks. Received on Wed Jul 23 2003 - 09:16:19 CDT