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