Re: ITC value is higher than MAXTRANS for index blocks
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: jonathan@xxxxxxxxxxxxxxxxxx
- Date: Fri, 25 Nov 2005 10:41:05 -0800
Jonathan:
I have also seen this in couple of cases earlier (with non ASSM
tablespace also). I suspect this could be a bug. The variable part of
the datablock can not exceed 50% of the block size and in practice we
don't need to allocate more 'itc' than 'nrows'. That is a total waste
of space,
KG
On 11/25/05, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx> wrote:
>
> 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
>
>
>
--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
