What are Recommended Guidelines to set INI_TRANS(Insertion Rates) For Table Indexes ? (Doc ID 2932543.1)

Last updated on JUNE 02, 2023

Applies to:

Goal

What are the guidelines for setting the INI_TRANS(Insertion Rate) value for table indexes?

According to Siebel Installation Guide

Insertion rates on tables. You probably will want to set the INI_TRANS value for tables with high insertion rates to a value higher than 1; a typical setting is 4.
This parameter determines how many simultaneous inserts can occur on the database blocks that store data for those tables and, therefore, can affect performance in an intensive data-entry environment. Use multiple free lists for the table S_DOCK_TXN_LOG, because this table receives numerous inserts.

Would like to understand whether INI_TRANS can be set for Indexes, if yes what are the recommended guidelines to set this value for both tables & respective table indexes? 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.