Monday, September 13, 2010

How to set ini_trans (initrans) value for tables and indexes?

alter table T1 initrans 64;


alter index I1 initrans 64;

Maximum effective value for INITRANS parameter depends on DB_BLOCK_SIZE parameter :-

BLOCK SIZE     Effective Value

==========     ==========
2048                           41
4096                           83
8192                         169

No comments:

Post a Comment