| 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.
I fully agree with Dennis. Even some applications like Oracle Finanacials
11i requires that min db_block size should be 8K. About 32K size, may be
some OS not support that size but 16K is much better for OLAP environment
and we have been using 8K for OLAT and 16K for OLAP/DSS.
Regards
Rafiq
From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Subject: RE: DB_BLOCK_SIZE??? Survey.
Date: Wed, 23 Jul 2003 08:09:31 -0800
Syed
The statement I received from an Oracle instructor is that the ability
to
handle blocks of a different size are in 9i for one purpose and one purpose
only -- so you can bring a transportable tablespace from another database.
Specifically, if you have databases with several block sizes you will be
able to move data to a data warehouse for reporting. I don't think Oracle
has even tested how well this feature works for other purposes. You might
get some performance gain with multiple block sizes, but you might also lose
performance if Oracle has to perform a lot of internal translation.
Chris
The common wisdom is to use 8K block_size for OLTP and either 16 or 32K for data warehouses. I've been creating new databases with these sizes.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, July 23, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
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-----
Sent: Wednesday, July 23, 2003 11:15 AM
To: Multiple recipients of list ORACLE-L
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 servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
INET: Syed.Ahmed_at_rci.rogers.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
INET: DWILLIAMS_at_LIFETOUCH.COM
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |