| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DB_BLOCK_SIZE??? Survey.
Chris,
I've been using 8k for the last few years for both data warehouse and oltp. Seems to work extremely well, especially over Oracle's 2k default.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----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 command for other information (like subscribing). Received on Wed Jul 23 2003 - 09:28:50 CDT
 |
 |