RE: Changing initrans

What Gopal wrote is correct, but I think he may have missed the part of the question about rebuilding the index.

If you dump some index blocks after you alter the initrans, but before you rebuild, you will see that the number beside kdxlebksz will not have changed.

After you continue with the alter index rebuild, of course your index will be in new blocks, but further, if you examine kdxlebksz, you'll see it is smaller. That is the evidence that more space is reserved for initrans entries. The byte offsets for the row# entries will also be different. If you play with different values for initrans, you'll see this number drift by 24 per initrans value change (though the 24 may change by release number, and I suppose they might change the kdxlebksz label as well).

Regards,

mwf

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K Gopalakrishnan
Sent: Wednesday, August 20, 2008 10:00 PM To: richa03_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Changing initrans

Rich,

Initrans is applicable only to future blocks. To prove: Do a simple block dump (search for alter system dump) and verify before and after the changes.

-Gopal

On Wed, Aug 20, 2008 at 5:26 PM, <richa03_at_gmail.com> wrote:
> If I rebuild an index online changing the initrans parameter, does it
> change initrans for all blocks of the index or just future blocks?
>
> Is there a method by which I can prove this?
>
> TIA,
> Rich
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l