RE: DB_BLOCK_SIZE??? Survey.

From: Syed Ahmed <Syed.Ahmed_at_rci.rogers.com>
Date: Wed, 23 Jul 2003 10:35:29 -0400
Message-Id: <25998.339133@fatcity.com>

Hi Chris,

Be default Oracle 9i create database with 4k block_size ,you can choose differently types of block_size on tablespace level. You may like to look into tablespace block_sizes. I have a 4 k block size in one of our production database but it allows me to have different block size on tablespace level.

Regards,

Syed Ahmed
Database Administrator
Technical Services. RSS
Rogers Communications Inc.
E-mail: sahmed4_at_rci.rogers.com
URL:http://www.rogers.com

-----Original Message-----
From: Grabowy, Chris [mailto:chris.grabowy_at_lmco.com] Sent: Wednesday, July 23, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L Subject: DB_BLOCK_SIZE??? Survey.

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.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Grabowy, Chris
  INET: chris.grabowy_at_lmco.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP Received on Wed Jul 23 2003 - 09:35:29 CDT