Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Where to find actual INITRANS for partitioned table.
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
Received on Thu Sep 04 2003 - 04:37:33 CDT