| 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
Personally, I don't like to use AUTOEXTEND on any datafiles. On more
than one occasion we've run into problems in which a datafile
autoextended to the point where there was no more room in the
filesystem. As a result, the issue now included not only the database,
but the OS as well. And, while recovering from this situation (e.g.,
moving a datafile to another filesystem) is not rocket science, it's yet
another complication in our already complicated lives.
I'd rather make use of monitors that warn us when we're close to filling a tablespace, at which time we have the luxury of deciding how to deal with the situation.
Just my $0.02...
FAX: 734-930-7611 E-Mail: jim.silverman_at_thomson.com From: oracle-l-bounce_at_freelists.org
Sent: Thursday, March 15, 2007 12:42 PM To: Oracle-L_at_freelists.org Subject: Auto Extend On, Increment By I have proposed to have all datafiles on all databasesautoextend with and increment size of 1280 blocks, (10Mbs).
Responses I am getting back are like: The increment should be based on the size of the datafile and how rapidly it's increasing in size. How to measure growth.
My reaction is like: Being consistent does not mean behavior will change in each situation. For datafiles that do not increase... they won't autoextend anyway. For datafiles that do extend, the ones that grow less will not extend very often. One datafile may extend once per week, and another twice a year. You don't have to have a 'size' that is proportional to how fast it grows.
I'm wondering what the communities reaction is before I respond.
Joel Patterson Database Administrator
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 15 2007 - 12:30:23 CDT
 |
 |