My Oracle Support Banner

AUTOEXTEND Grows To Full Size Without Reason (Doc ID 1459097.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.