Re: Multiple block sizes

2003-09-26 Thread Tanel Poder
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

Re: Multiple block sizes

2003-09-25 Thread Tanel Poder
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

Re: Multiple block sizes

2003-09-25 Thread Wolfgang Breitling
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

Re: Multiple block sizes

2003-09-25 Thread Tanel Poder
, 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

Re: Multiple block sizes

2003-09-25 Thread Wolfgang Breitling
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

Multiple block sizes

2003-09-24 Thread Mladen Gogala
Title: Message 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

RE: Multiple block sizes

2003-09-24 Thread Igor Neyman
Title: Message Dont have experience with that. But, dont 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

RE: Multiple block sizes

2003-09-24 Thread Mladen Gogala
block sizes Dont have experience with that. But, dont 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

RE: Multiple block sizes

2003-09-24 Thread Avnish.Rastogi
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

RE: Multiple block sizes

2003-09-24 Thread Mladen Gogala
, 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

RE: Multiple block sizes

2003-09-24 Thread John Kanagaraj
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

RE: Multiple block sizes

2003-09-24 Thread Avnish.Rastogi
, 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

Multiple block sizes in 9i

2003-01-16 Thread Jos
List, Oracle 9i supported multiple block sizes, I am wondering under what circumstancesone would setup a database with multiple block sizes? Jos Yahoo! Greetings - Send your seasons greetings online this year!

RE: Multiple block sizes in 9i

2003-01-16 Thread Chris Stephens
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

AW: Multiple block sizes in 9i

2003-01-16 Thread Stefan Jahnke
3 14:14An: Multiple recipients of list ORACLE-LBetreff: Multiple block sizes in 9i List, Oracle 9i supported multiple block sizes, I am wondering under what circumstancesone would setup a database with multiple block sizes? Jos Yahoo! Greetings- Send your seasons greeti

RE: Multiple block sizes in 9i

2003-01-16 Thread Toepke, Kevin M
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

Re: Oracle9i with multiple block sizes

2002-02-11 Thread Connor McDonald
/cust9/monidx.dbf 8192 Cheers Connor --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Hi, Anyone running oracle9i with multiple datablock sizes in their database...? I am looking for the result for this query from a database which has multiple block sizes? SELECT *FROM X$KVIS

Oracle9i with multiple block sizes

2002-02-10 Thread K Gopalakrishnan
Hi, Anyone running oracle9i with multiple datablock sizes in their database...? I am looking for the result for this query from a database which has multiple block sizes? SELECT *FROM X$KVIS: You can reply to me directly if you choose to do so. Best Regards, K Gopalakrishnan Bangalore, INDIA