INITRANS benefit in tables and indexes with high I/O


If you increase the INITRANS parameter in tables and indexes with very high I/O, it will make less I/O because multiple operations can be performed.

You can change this parameter as follows.


To query the current value;


To change the current value;

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *