Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 - 08:02:40 CDT
![]() |
![]() |