Re: Autoextend or not?

  • From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
  • To: Jared Still <jkstill@xxxxxxxxx>
  • Date: Tue, 14 Apr 2009 01:43:21 -0300


  I think you hit the nail there, if yo have space to spare, then
autoextend can be a good thing, and as Nuno said, limiting it so the
FS never runs out of space can save you a lot of calls during the
night... I am not sure, however, if it has any impact on performance,
or if it would make it necessary to defragment FS or to redifne
objects inside the growing DFs.

   In any case, for out particular environment, there is little space
left on any one filesystem, and customer is charged by GB, so they are
not so keen on having unused space in the servers... that's why
autoextend is not the best option for us.

    I can see, however, that there are no technical advantages to
autoextend, while there are many other advantages, and really good
ones indeed.

Thank you all :-)

Alan Bort
Oracle Certified Professional

On Mon, Apr 13, 2009 at 10:15 PM, Jared Still <jkstill@xxxxxxxxx> wrote:
> On Mon, Apr 13, 2009 at 2:33 AM, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
> wrote:
>> So,
>>   We have a debate going on about allowing databases with datafiles
>> with autoextend on... anybody has any input on this? any experience?
>> My side: I don't like autoextend, I can't trust the unix team to do
>> their job and I can't allow for a datafile to fill up the FS. Then
>> again, I can't trust monitoring tools to do their job, so autoextend
>> *could* save the day.
> At first I didn't like the autoextend idea.
> It grew on me however as I have to spend less time thinking about space.
> Most servers are now oversubscribed for storage on their respective servers,
> we keep an eye on disk space and don't worry about it much.
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: