I am an Oracle Database Specialist in Singapore.
EU visitors : Please note that this site uses cookies.

19 April, 2016

Partition Storage -- 1 : Default Partition Sizes in 12c

11g 11.2.0.2 introduced a change whereby the default Initial Extent of a Table Partition was 8MB. However, this did not apply to Index Partitions which could still start with 64KB extents in an AutoAllocate Tablespace.

12cR1 now introduces a parameter to enable large Initial Extent for Index Partitions as well.