RE: PCTFREE and ITL space on high insert table

> The three ITL slots appears for "create table as select", and "alter table move".

I may misunderstood Michael, but doesn't he want to move his partitions? Quote: "I am moving the table partitions to another tablespace and am wondering if I can change to PCTFREE 0". So finally he will end up with at least 3 ITL slots.   

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> hat am 4. Mai 2016 um 11:35 geschrieben:
>
>
> Stefan,
>
> The three ITL slots appears for "create table as select", and "alter table move".
> If you create an empty table and insert into it you get 2 ITL slots per block. I think this appeared in 10g at the same time that MAXTRANs ceased to
> have any effect.
>
>
> Regards
> Jonathan Lewis
> http://jonathanlewis.wordpress.com
> _at_jloracle

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