Re: Initrans

INITRANS is the initial number of ITEs (transaction slots) in a block. MAXTRANS is the maximum number of ITEs in a block (if space allows). Each concurrent transaction modifying a row in a block needs its own ITE. Unless each transaction will be modifying rows in a single block, setting it to the average number of tx will waste space. Small rows in big blocks that are modified constantly need a high number of ITEs. Large rows in small blocks that are rarely modified need a low number of ITEs. For a high concurrency object, set INITRANS to a reasonable (but small) number, e.g. 4. Make sure you leave enough space in the block to enable additional ITEs if you are wrong. I don't recall testing this, but I *think* that once an ITE is created, it is not removed from the block header.

Daniel

Hamid Alavi wrote:

>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
>
>Office : 818-737-0526
>Cell phone : 818-416-5095
>
>
>
>
>
>======================= Confidentiality Statement =======================
>The information contained in this message and any attachments is
>intended only for the use of the individual or entity to which it is
>addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL
>and exempt from disclosure under applicable law. If you have received
>this message in error, you are prohibited from copying, distributing, or
>using the information. Please contact the sender immediately by return
>e-mail and delete the original message from your system.
>===================== End Confidentiality Statement =====================
>
>
>--
>To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
>To search the archives - http://www.freelists.org/archives/oracle-l/
>
>

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