Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to 220.127.116.11 or Later
(Doc ID 1295484.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [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 126.96.36.199 has default initial extent size 8MB vs 64KB in previous versions.
Table created in 188.8.131.52 having many partitions with few rows in each, consumes more space than in earlier versions.
Upgrade to 184.108.40.206 or later from releases earlier than 220.127.116.11
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 18.104.22.168 and above (upto 22.214.171.124, the latest checked)|
|How to Achieve the Pre-126.96.36.199 Behaviour|
|How to query the value of this parameter|