AUTOEXTEND Grows To Full Size Without Reason
(Doc ID 1459097.1)
Last updated on FEBRUARY 24, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
In some cases, a datafile with AUTOEXTEND enabled grows to its max size when it is not even filled near its current size. This only seems to happen on very large tablespaces - 150GB+. On smaller tablespaces, it behaves as expected.
Tablespace XXXX is composed of six data files, has an allocated size of 157,424MB with 156,663MB used.
Data file #6 (XXXX_06.dbf) has an allocated size of 2800MB with 2042MB used.
I set AUTOEXTEND to increment by 100MB with a max size of 3800MB but minutes after I activated AUTOEXTEND, the data file had been increased to its max size but the used space had not increased anywhere near the allocated size. As proof the extra space was not used, I was able to shrink the data file back to 2800MB
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