RE: PCTFREE and ITL space on high insert table
Date: Wed, 4 May 2016 12:43:39 +0200 (CEST)
Message-ID: <1692054147.1102268.1462358620009.JavaMail.open-xchange_at_app03.ox.hosteurope.de>
Hi Jonathan,
thanks for verifying the version.
> 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-lReceived on Wed May 04 2016 - 12:43:39 CEST