INITRANS benefit in tables and indexes with high I/O

dbtut

6 years ago

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 ;