RE: sudden datafile growth with autoextend of 10Mbs

  • From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
  • To: "'jpatterson@xxxxxxxxxx'" <jpatterson@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Dec 2013 17:25:09 +0000

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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Patterson, Joel
Sent: Wednesday, 11 December, 2013 09:50
To: oracle-l@xxxxxxxxxxxxx
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 11.2.0.3.3 and the datafiles autoextend at 10Mbs ( 
dba_data_files - 1280 increment by @ 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@xxxxxxxxxx<mailto:jpatterson@xxxxxxxxxx>
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://www.facebook.com/pages/Enterprise-Integration/212351215444231]<http://www.facebook.com/pages/Enterprise-Integration/212351215444231>
  [http://twitter.com/#!/entint] <http://twitter.com/#!/entint>   
[http://www.linkedin.com/company/18276?trk=tyah] 
<http://www.linkedin.com/company/18276?trk=tyah>   
[http://www.youtube.com/user/ValueofIT] <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]

Other related posts: