RE: Changing initrans
Date: Thu, 21 Aug 2008 07:09:32 -0400
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).
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
Subject: Re: Changing initrans
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.
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?
-- 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-lReceived on Thu Aug 21 2008 - 06:09:32 CDT