Re: ITC value is higher than MAXTRANS for index blocks
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <dba.orcl@xxxxxxxxx>, "oracle list" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Nov 2005 08:29:14 -0000
I saw your post on AskTom, and followed that one up
before I got this. But in direct answer to your question.
It IS possible to get itc > maxtrans on TABLES (because
of the oddity I describe in the note on AskTom), so
maybe it can happen on indexes too.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Nov 2005
----- Original Message -----
From: "Sami Seerangan" <dba.orcl@xxxxxxxxx>
To: "oracle list" <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, November 24, 2005 9:47 PM
Subject: ITC value is higher than MAXTRANS for index blocks
Dear All,
Env:
Oracle 9.2.0.6 3-Node RAC,Sun OS 2.9
Block size 16K
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
