RE: Multiple block sizes
Title: Message Don’t have experience with that. But, don’t forget to configure memory subcaches for multiple block sizes (along with specifying new block size for the tablespace). Check “Oracle 9i New Features” by R.Freeman (p.13). Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: Wednesday, September 24, 2003 11:05 AM To: Multiple recipients of list ORACLE-L Subject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: Multiple block sizes
Title: Message That part is done. Thanks. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor NeymanSent: Wednesday, September 24, 2003 12:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes Don’t have experience with that. But, don’t forget to configure memory subcaches for multiple block sizes (along with specifying new block size for the tablespace). Check “Oracle 9i New Features” by R.Freeman (p.13). Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen GogalaSent: Wednesday, September 24, 2003 11:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: Multiple block sizes
Title: Message I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but you can think about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: Multiple block sizes
Title: Message Great! You're exactly the guy that I was looking for. Any problems encountered/advice to give? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but you can think about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: Multiple block sizes
Title: Message Mladen/Avinish, I would just be a little careful about keeping 'hot' indexes in 32K blocks. The chances of encountering buffer busy waits during multiple, simultaneous INSERTs and DELETEs would be higher as root blocks and branch blocks that need to be updated would now hold a larger number of entries and thus be more likely candidates for block contention Same is the case with more chances of running out of ITL space/entries in hot data blocks. IMHO, DSS type applications benefit most from larger block sizes and support for multiple block sizes in 9i was provided so that 'large-blocksize' tablespaces that contain transaction history can be transported from a 'otherwise-small blocksize' based OLTP database into DSS databases that traditionally have large block sizes. For e.g. in a 9i Db, you might have the OLTP tables based on 8K blocksized tablespaces, create monthly history from these transaction tables into a 32K blocksize based tablespace in the same 9i database so that you can Tablespace-Transport it to a 9i, 32k blocksized DSS database. Back to imbibing a thick, black brew after writing this complicated note :) John KanagarajDB Soft IncPhone: 408-970-7002 (W)Grace - Getting something we do NOT deserveMercy - NOT getting something we DO deserveClick on 'http://www.needhim.org' for Grace and Mercy that is freely available!** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 12:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes Great! You're exactly the guy that I was looking for. Any problems encountered/advice to give? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but you can think about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. Note: This messa
RE: Multiple block sizes
Title: Message Not really, except to watch closely your hit ratio for no default cache other than that we used alter table move and alter index rebuild online option to move tables/indexes. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 12:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes Great! You're exactly the guy that I was looking for. Any problems encountered/advice to give? --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 1:55 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but you can think about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
Re: Multiple block sizes
Title: Message Hi! I think putting your small tables to 2K block size is quite pointless (unless you have tens of thousands of these tables continously in buffer cache). Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 8:54 PM Subject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but you can think about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Wednesday, September 24, 2003 9:05 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes Does anybody have any experience with the multiple block sizes in the database? I'm about to reconfigure my database to have a tablespace with blocksize 16k in addition to the existing 8k tablespaces. Tables in this tablespace will be loaded weekly and read daily, frequently using full table scan (DW style reporting. I'm planning to have bitmap indexes and the rest of the DW arsenal). Does anybody have any negative experiences with that kind of stuff? It's 9.2.0.4 on RH 7.3. Am I running into ora-7445 and ora-0600 type errors? --Mladen GogalaOracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
Re: Multiple block sizes
I'm not there yet, at least not in production, but I am looking forward to putting thousands of small (actually empty) tables and indexes of Peoplesoft Financials into a 2K tablespace. Not that they will ever occupy any room in the buffer pool, but just for the savings in disk space (and backup time until we go to RMAN and incremental backups). 10,000 tables occupying 2 2K blocks instead of 2 8K blocks is a savings of almost 120M. In order not to waste the 2K buffer pool I'll find a few suitable lookup tables that could benefit from what will then be a keep pool. At 07:44 AM 9/25/2003 -0800, you wrote: Hi! I think putting your small tables to 2K block size is quite pointless (unless you have tens of thousands of these tables continously in buffer cache). Tanel. - Original Message - From: <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED] To: <mailto:[EMAIL PROTECTED]>Multiple recipients of list ORACLE-L Sent: Wednesday, September 24, 2003 8:54 PM Subject: RE: Multiple block sizes I have little bit experience on that. I am keeping indexes in 32K block 'cause Oracle access indexes sequentially and placing indexes in large block would help in reducing IO. All the tables are in 8K block size but you can think about putting small tables in 2K or 4KB block size to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: Multiple block sizes
Wolfgang, Well, I do understand the buffer cache usage part, but few hundred megs of disk space and 20 seconds of backup time savings wouldn't make me to start experimenting with block sizes like that. I assume index organized tables would be the best solution if you got huge amount of tiny lookup tables, but yeah, in packaged app you can't just start changing physical structure... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 9:59 PM > I'm not there yet, at least not in production, but I am looking forward to > putting thousands of small (actually empty) tables and indexes of > Peoplesoft Financials into a 2K tablespace. Not that they will ever occupy > any room in the buffer pool, but just for the savings in disk space (and > backup time until we go to RMAN and incremental backups). 10,000 tables > occupying 2 2K blocks instead of 2 8K blocks is a savings of almost 120M. > In order not to waste the 2K buffer pool I'll find a few suitable lookup > tables that could benefit from what will then be a keep pool. > > At 07:44 AM 9/25/2003 -0800, you wrote: > >Hi! > > > >I think putting your small tables to 2K block size is quite pointless > >(unless you have tens of thousands of these tables continously in buffer > >cache). > > > >Tanel. > > > >- Original Message - > >From: <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED] > >To: <mailto:[EMAIL PROTECTED]>Multiple recipients of list ORACLE-L > >Sent: Wednesday, September 24, 2003 8:54 PM > >Subject: RE: Multiple block sizes > > > >I have little bit experience on that. I am keeping indexes in 32K > >block 'cause Oracle access indexes sequentially and placing indexes in > >large block would help in reducing IO. All the tables are in 8K block > >size but you can think about putting small tables in 2K or 4KB block size > >to better utilize your RAM. We are on AIX 5.1 , Oracle 9202. > > Wolfgang Breitling > Oracle7, 8, 8i, 9i OCP DBA > Centrex Consulting Corporation > http://www.centrexcc.com > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Wolfgang Breitling > 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: Tanel Poder 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: Multiple block sizes
They are not even lookup tables, just dead weight. These off the shelf ERP products are so generic, trying to be everything for everyone, that any particular installation uses only a fraction of all the tables. Especially when you consider that sine Peoplesoft 8, you create all tables for all modules, even those that you didn't buy a license for. Granted, what are a few 100 meg in today's mega-gigabyte databases. But something in me abhors any waste, be it space or time (i.e. performance). And since I have relegated those tables already to their own "TINYTBL" tablespace with uniform 2-block extents, it is really no additional work to create it with the smalled blocksize possible. At 03:34 PM 9/25/2003 -0800, you wrote: Wolfgang, Well, I do understand the buffer cache usage part, but few hundred megs of disk space and 20 seconds of backup time savings wouldn't make me to start experimenting with block sizes like that. I assume index organized tables would be the best solution if you got huge amount of tiny lookup tables, but yeah, in packaged app you can't just start changing physical structure... Tanel. Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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: Multiple block sizes
Yep, in Apps 11i there's also more than 10k tables, over 150k objects total in database - quite a hit for data dictionary :) Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 5:54 AM > They are not even lookup tables, just dead weight. These off the shelf ERP > products are so generic, trying to be everything for everyone, that any > particular installation uses only a fraction of all the tables. Especially > when you consider that sine Peoplesoft 8, you create all tables for all > modules, even those that you didn't buy a license for. Granted, what are a > few 100 meg in today's mega-gigabyte databases. But something in me abhors > any waste, be it space or time (i.e. performance). And since I have > relegated those tables already to their own "TINYTBL" tablespace with > uniform 2-block extents, it is really no additional work to create it with > the smalled blocksize possible. > > At 03:34 PM 9/25/2003 -0800, you wrote: > >Wolfgang, > > > >Well, I do understand the buffer cache usage part, but few hundred megs of > >disk space and 20 seconds of backup time savings wouldn't make me to start > >experimenting with block sizes like that. > > > >I assume index organized tables would be the best solution if you got huge > >amount of tiny lookup tables, but yeah, in packaged app you can't just start > >changing physical structure... > > > >Tanel. > > Wolfgang Breitling > Centrex Consulting Corporation > http://www.centrexcc.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Wolfgang Breitling > 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: Tanel Poder 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: Multiple block sizes in 9i
There are other reasons for this but... I think the primary reason is to server data warehouse functions. i.e. if you have an oltp database with a small block size and want that data into a staging area as quickly as possible, you are now able to use transportable tablespaces because the 'same block size' restriction has been removed. chris -Original Message-From: Jos [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 7:14 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes in 9i List, Oracle 9i supported multiple block sizes, I am wondering under what circumstances one would setup a database with multiple block sizes? Jos Yahoo! Greetings- Send your seasons greetings online this year!
RE: Multiple block sizes in 9i
Using transportable tablespaces to move data from the operational database to the ODS or warehouse is one. -Original Message-From: Jos [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 8:14 AMTo: Multiple recipients of list ORACLE-LSubject: Multiple block sizes in 9i List, Oracle 9i supported multiple block sizes, I am wondering under what circumstances one would setup a database with multiple block sizes? Jos Yahoo! Greetings- Send your seasons greetings online this year!