| 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.
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-----
From: Syed Ahmed [mailto:Syed.Ahmed_at_rci.rogers.com]
Sent: Wednesday, July 23, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: DB_BLOCK_SIZE??? Survey.
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 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).
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 Received on Wed Jul 23 2003 - 10:03:10 CDT
 |
 |