AUTOEXTEND Grows To Full Size Without Reason
Last updated on FEBRUARY 12, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms