Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance tuning

Re: Performance tuning

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 03 Nov 2004 03:12:23 GMT
Message-ID: <Xns9595C3615C39CSunnySD@68.6.19.6>


ed.prochak_at_magicinterface.com (Ed prochak) wrote in news:4b5394b2.0411021032.567c3229_at_posting.google.com:

> msmajhail_at_gmail.com (manny) wrote in message
> news:<b7d514bd.0411012305.84926ca_at_posting.google.com>...

>> 1/ INITRANS is a parameter that indicates the concurrency level of
>> transactions when working inside a db block. Where is this parameter
>> stored?
>> When and how can this be set/changed? 

>
> It's an option on
> CREATE TABLE
> ALTER TABLE
> commands.

AFAIK, INITRANS can only be changed at object (table, index, etc.) creation time.
The result is physical disk space reserved within EVERY block. Received on Tue Nov 02 2004 - 21:12:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US