Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Auto Extend On, Increment By

RE: Auto Extend On, Increment By

From: <>
Date: Fri, 16 Mar 2007 08:07:40 -0400
Message-ID: <>

I've done it both ways, I'd like to get GRID involved. The fact of the matter is, our databases hardly grow at all. The disk available space is monitored by two tools and the system admins also.  

It seems so much easier in this situation. We do not do loads here. My issue is mainly what difference does it really make in this situation what size the increment_by is? 1280 blocks. Sounds good, and if some extend more often... oh well... there is a small performance hit then. (OLTP). I can do bigger.  

As a sidenote, to save time. I have just installed and upgraded EM GRID database, repository, OMS and agents. However, have never depended on it or gotten familiar yet. (I am, don't send me all the links to the manuals). I have used the console. Anyway, in this case, to save time, I would like to dive straight to the monitoring portion that EM can do for me with this issue:  

Rate of growth of datafiles. Available disk space is a default. With LMT and autoextend, and limited growth, I just don't see why I have to page myself watching tablespace free space. I am by myself as a DBA, I hardly get called, but I am still 24/7, and don't need "at this point in the reorganization of the databases" to burdon myself with extra monitoring pages.  

Sorry, the situation here is not as hot as a lot of you have it, perhaps that is why there is 'resistance' :-)  


Joel Patterson
Database Administrator
904 727-2546

From: Dennis Williams [] Sent: Thursday, March 15, 2007 8:00 PM
To: Patterson, Joel
Subject: Re: Auto Extend On, Increment By  


If you decide to switch to autoextend, I think this is the least issue to decide. The important issue is how space will be monitored. Done right, autoextend can give you a single space indicator to monitor. But make sure none of your tables have a limit of extents or you'll get a failure even though you still have disk space.  

Dennis Williams

Received on Fri Mar 16 2007 - 07:07:40 CDT

Original text of this message