Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Auto Extend On, Increment By
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_at_crowley.com <Joel.Patterson_at_crowley.com> 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_at_crowley.com
> x72546
> 904 727-2546
> ------------------------------
>
> *From:* goran bogdanovic [mailto:goran00_at_gmail.com]
> *Sent:* Thursday, March 22, 2007 9:03 AM
> *To:* Patterson, Joel
> *Cc:* Oracle-L_at_freelists.org
> *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_at_crowley.com* <Joel.Patterson_at_crowley.com>
> 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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 22 2007 - 11:22:23 CDT
![]() |
![]() |