INITRANS benefit in tables and indexes with high I/O

dbtut October 9, 2018 ORACLE

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.

SQL> SELECT ini_trans, max_trans from dba_tables WHERE table_name = 'TEST' ;

INI_TRANS  MAX_TRANS
---------- ----------
5        255

SQL> SELECT ini_trans, max_trans from dba_tables WHERE table_name = 'TEST' ;

INI_TRANS MAX_TRANS

---------- ----------

5 255

SQL> ALTER TABLE TEST INITRANS 5 MAXTRANS 255 ;

1	SQL> ALTER TABLE TEST INITRANS 5 MAXTRANS 255 ;

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux