Re: Auto Extend On, Increment By

  • From: "goran bogdanovic" <goran00@xxxxxxxxx>
  • To: "Joel.Patterson@xxxxxxxxxxx" <Joel.Patterson@xxxxxxxxxxx>
  • Date: Thu, 22 Mar 2007 17:22:23 +0100

since you didn't mention what are your recovery requirements and how fast
your datafiles/databases are growing, what I meant, if you set autoextend on
datafiles, the datafiles can grow so to say as long as there are place on
storage...in case you have to recover some of the datafiles, restore and
recovery of 50GB datafile is not the same as of 5GB datafile...or your
environment is such that this is not relevant...in such case, please ignore
my e-mail :-)

On 3/22/07, Joel.Patterson@xxxxxxxxxxx <Joel.Patterson@xxxxxxxxxxx> wrote:


 What?



I your thinking that dozens of files are going to extend and cause longer
recovery times because they might have 10Mbs of extra space in them, (with
RMAN that's not even an issue), when the files are in the 20's of GBs (that
is a miniscule amount of space), ….then it has been considered.





Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904  727-2546
  ------------------------------

*From:* goran bogdanovic [mailto:goran00@xxxxxxxxx]
*Sent:* Thursday, March 22, 2007 9:03 AM
*To:* Patterson, Joel
*Cc:* Oracle-L@xxxxxxxxxxxxx
*Subject:* Re: Auto Extend On, Increment By



Hi Joel,

In setting autoextend on I would consider recovery requirements too...

Regards,
Goran

 On 3/15/07, *Joel.Patterson@xxxxxxxxxxx* <Joel.Patterson@xxxxxxxxxxx>
wrote:

I have proposed to have all datafiles on all databases autoextend 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007