ITC value is higher than MAXTRANS for index blocks

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Thu, 24 Nov 2005 16:47:47 -0500
Message-ID: <f09dd6280511241347j66c22113hbc0bd8c0d715c56b@mail.gmail.com>

Dear All,

Env:
Oracle 9.2.0.6 3-Node RAC,Sun OS 2.9
Block size 16K

LMT with ASSM.

create table t1(c1 varchar2(4000),c2 number); alter table t1 add constraint t1_pk primary key (c1) using index initrans 2 maxtrans 4 pctfree 99;

Session1

---

insert into t1 values(lpad('A',3999,'A'),1);

1 row inserted.

Session2

---

insert into t1 values(lpad('B',3999,'A'),1);

1 row inserted.

Session3

---

insert into t1 values(lpad('C',3999,'A'),1);

1 row inserted.
Session4

---

insert into t1 values(lpad('D',3999,'A'),1);

Session hangs..... because of ITL wait. Not an issue

At this point we took block dump for an index using below statement; select 'alter system dump datafile 9 block min '||c1||' block max '||c2||';' from (select block_id c1,(block_id + blocks-1) c2 from dba_extents where segment_name='T1_PK')
SQL> / 'ALTERSYSTEMDUMPDATAFILE9BLOCKMIN'||C1||'BLOCKMAX'||C2||';'

---

alter system dump datafile 9 block min 23889 block max 23896;

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

Question:
Is it possible to have ITC value higher than MAXTRANS value?

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

Received on Thu Nov 24 2005 - 15:49:51 CST