My Oracle Support Banner

Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to or Later (Doc ID 1295484.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


Table partition created in has default initial extent size 8MB vs 64KB in previous versions.
Table created in having many partitions with few rows in each, consumes more space than in earlier versions.


Upgrade to or later from releases earlier than


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Explanation of the default behaviour in and above (upto, the latest checked)
 How to Achieve the Pre- Behaviour
 How to query the value of this parameter

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.