| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Auto Extend On, Increment By
Joel,
This whole discussion always is defined by your current infrastructure. In your case, you have slow steady growth, so an active auto-extend infrastructure and monitoring process probably does not make sense.
But for those of us who have databases that either grow regularly, or have active batch loads, auto-extend and active disk growth monitoring is a requirement. I certainly do not want to be called to work because an Oracle data file is full when there is enough room on disk where it can grow by itself. Of course, once you turn this on, you need a monitoring process to forecast when you will fill disk and when you need to inform management that more disk needs to be purchased.
So there is no right or wrong way to do this. As with all things, Oracle gives us the ability to allow the database to grow automatically. But we don't need to use it.
Tom
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Joel.Patterson_at_crowley.com
Sent: Friday, March 16, 2007 8:08 AM
To: oracledba.williams_at_gmail.com; tim_at_evdbt.com
Cc: Oracle-L_at_freelists.org
Subject: 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-lReceived on Fri Mar 16 2007 - 07:50:48 CDT
 |
 |