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