RE: Auto Extend On, Increment By

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 10.2.0.2 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' :-)  

Thanks,  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] Sent: Thursday, March 15, 2007 8:00 PM
To: Patterson, Joel
Cc: Oracle-L_at_freelists.org
Subject: Re: Auto Extend On, Increment By  

Joel,  

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

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