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: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Many thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Syed Ahmed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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. [EMAIL PROTECTED] -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: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Many thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Syed Ahmed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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. [EMAIL PROTECTED] -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: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Many thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Syed Ahmed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services