RE: ITC value is higher than MAXTRANS for index blocks

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 25 Nov 2005 08:38:29 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF2052AC@MSXVS04.trivadis.com>

Sami

>The block dump shows ITC value as 255 for 3 out of 8 blocks even
>though the maxtrans value is defined as 4.

Do those 3 blocks already contain index data?

>Is it possible to have ITC value higher than MAXTRANS value?

This is definitively the case in 10g where MAXTRANS it's deprecated and automatically set to 255 (i.e. the theoretical maximum... in practice it could be smaller). Note that in 10g DBA_INDEXES.MAX_TRANS contains the actual value, not the value specified by the DDL statement.

Anyway, I never saw this behavior it in 9i. What does DBA_INDEXES.MAX_TRANS contain in your case?

HTH
Chris

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

Received on Fri Nov 25 2005 - 01:40:32 CST