sudden datafile growth with autoextend of 10Mbs

From: Patterson, Joel <jpatterson_at_entint.com>
Date: Wed, 11 Dec 2013 09:49:42 -0500
Message-ID: <C1117B1AA0340645894671E09A7891F71569177DD5_at_EIHQEXVM2.ei.local>

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 11.2.0.3.3 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.

Thanks,

Joel Patterson
Senior Oracle Database Administrator
jpatterson_at_entint.com<mailto:jpatterson_at_entint.com> Office: 904 928-2790
Enterprise Integration Corporation / www.entint.com<http://www.entint.com/> 7601 Centurion Parkway | Jacksonville, FL 32256

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



[http://i1202.photobucket.com/albums/bb367/Entint/signaturev61.jpg]<http://www.entint.com/>




[http://i1202.photobucket.com/albums/bb367/Entint/th_FaceBook1.jpg]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231>  [http://i1202.photobucket.com/albums/bb367/Entint/th_Twitter1.jpg] <http://twitter.com/#!/entint>   [http://i1202.photobucket.com/albums/bb367/Entint/th_LinkedIn1.jpg] <http://www.linkedin.com/company/18276?trk=tyah>   [http://i1202.photobucket.com/albums/bb367/Entint/th_YouTube1.jpg] <http://www.youtube.com/user/ValueofIT>


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]

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 11 2013 - 15:49:42 CET