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

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

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.


Example:
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms