Re: Performance tuning

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 3 Nov 2004 14:27:14 +1100
Message-ID: <41884ffe$0$32541$afc38c87@news.optusnet.com.au>

"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> wrote in message news:Xns9595C3615C39CSunnySD_at_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.

I understand the cover-my-back attitude that accompanies the 'AFAIK' moniker you prepended to that bit of technical insight. But don't you think you might just have taken three seconds out to try it out for yourself and for real? If you had, you would have gotten this result:

C:\Documents and Settings\howardjr>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Nov 3 14:24:42 2004

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> alter table scott.emp initrans 2;

Table altered.

Which kind of means what you wrote isn't in fact the case.

HJR
> The result is physical disk space reserved within EVERY block.
Received on Tue Nov 02 2004 - 21:27:14 CST