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;

dbtut
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 *