RE: sudden datafile growth with autoextend of 10Mbs

From: Uzzell, Stephan <SUzzell_at_MICROS.COM>
Date: Wed, 11 Dec 2013 17:25:09 +0000
Message-ID: <>

You don't give quite enough information to rule this in or out, but have you looked at AUTOEXTEND Grows To Full Size Without Reason (Doc ID 1459097.1)?

Stephan Uzzell

From: [] On Behalf Of Patterson, Joel Sent: Wednesday, 11 December, 2013 09:50 To:
Subject: sudden datafile growth with autoextend of 10Mbs

My sysadmin verifies that all of a sudden 13Gbs of free space was lost overnight. (and we have narrowed down the file).

The database is and the datafiles autoextend at 10Mbs ( dba_data_files - 1280 increment by _at_ 8192 blocksize). The tablespace holds almost exclusively one CLOB column of one table.

Sure enough, I can check the high water mark and subtract from the smallest hwm and see there is empty space, and I can shrink the datafile back down accordingly. This happens periodically. The growth is not an issue, but I am trying to understand why the growth is 13Gbs over night? Related to the CLOB field? Why not 10Mbs only? A majority of my DB's are set this way, and I do not see that type of sudden extending.


Joel Patterson
Senior Oracle Database Administrator<> Office: 904 928-2790
Enterprise Integration Corporation /<> 7601 Centurion Parkway | Jacksonville, FL 32256

Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916<>


[]<> [!/entint] <!/entint> [] <> [] <>
This message (and any associated files) is intended only for the use of the addressee and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient, you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company. [v.1.1] --
Received on Wed Dec 11 2013 - 18:25:09 CET

Original text of this message