RE: Initrans

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 careful.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all

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

List,

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?
Thanks,

Hamid Alavi

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/