Re: Initrans
- From: "Daniel W. Fink" <Daniel.Fink@xxxxxxx>
- To: hamid.alavi@xxxxxxxxxxx
- Date: Thu, 09 Sep 2004 09:53:05 -0600
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@xxxxxxxxxxxxx&subject=unsubscribe
>To search the archives - //www.freelists.org/archives/oracle-l/
>
>
--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To search the archives - //www.freelists.org/archives/oracle-l/
Other related posts:
