PCTFREE and ITL space on high insert table

I have a table that receives a relatively high number of INSERTs (no updates or deletes). They come in at a peak rate of about 400 per second on a partitioned table with local indexes. Only the last partition receives inserts and there is a total of 2B rows per partition. My question is for both the PCTFREE on both table and index.

I am moving the table partitions to another tablespace and am wondering if I can change to PCTFREE 0. My concern is if there will be enough space in the block header for the required number of ITL entries.

The source for this question is from Jonathan Lewis' book Oracle Core on page 37 where it says "but the ITL in any block can grow dynamically if it needs to, provided there is enough free space available in the block". I may have misunderstood what this means, but if PCTFREE 0 fills the block will there still be enough room in the block header for the ITL lists?

Thanks,
--

Michael Cunningham

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 04 2016 - 01:17:06 CEST