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
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
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
, 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
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
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
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
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
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
,
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
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
, 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
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!
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
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
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
/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
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
18 matches
Mail list logo