AUTOEXTEND Grows To Full Size Without Reason
(Doc ID 1459097.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 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 APPS_TS_TX_IDX is composed of six data files, has an allocated size of 157,424MB with 156,663MB used.
Data file #6 (APPS_TS_TX_IDX06.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 anywahere 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