Re: Where to find actual INITRANS for partitioned table.

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 4 Sep 2003 20:04:25 +1000
Message-ID: <3f570e96$0$14558$afc38c87@news.optusnet.com.au>

"Erik Ykema" <erik.ykema_at_xs4all.nl> wrote in message news:2a2f090c.0309040137.26e0fd77_at_posting.google.com...
> Dear OPs,
> I have not been able to find SQL-documentation for the following
> information: what is the initrans, maxtrans for my partitioned table.
> In dba_tables, those columns are null. I have done an 'alter table
> table_a initrans 7' and this doesn't show up here.
> I wish to see the current ITL-settings for several PTs.
> Also: where can I find PCT_FREE, PCT_USED, INITIAL_EXTENT,
> NEXT_EXTENT, MIN_EXTENTS, MAX_EXTENTS, PCT_INCREASE, FREELISTS,
> FREELIST_GROUPS for my partitioned tables?
> Thanks in advance,
> erik.ykema.removethis_at_xs4all.removethis.nl

Try DBA_TAB_PARTITIONS

Regards
HJR Received on Thu Sep 04 2003 - 05:04:25 CDT