RE: Initrans

  • From: "Steve Adams" <steve.adams@xxxxxxxxxxxx>
  • To: <hamid.alavi@xxxxxxxxxxx>, "''Oracle-L (E-mail)'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 10 Sep 2004 06:53:39 +1000

Hi Hamid,

No, don't set INITRANS to a non-default value unless you need to do so
to avoid ITL waits. ITL waits are counted in V$SEGSTAT. The ITL can
grow dynamically and preallocating extra slots just wastes space.
Instead, ensure that you never set PCTFREE to zero, except on truly
read-only tables.

Only set FREELISTS on tables that get enough concurrent inserts to
cause dynamic ITL growth. Take a few block dumps, and use the highest
ITL size seen, raised to the next prime. There is very little downside
here, only a few more block below the HWM, so you don't have to be too

@   Regards,
@   Steve Adams
@         - For DBAs
@  - For all 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Hamid Alavi
Sent: Friday, 10 September 2004 1:49 AM
To: 'Oracle-L (E-mail)
Subject: Initrans


I have heared the best number for Initras is the number of CPU but what
about the Freelists is there any standard for this parameter too.
Any idea for any standards for  these two parameters?  Number of CPU or
average number of Transaction or what?

Hamid Alavi

To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives -

Other related posts: