Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Auto Extend On, Increment By

RE: Auto Extend On, Increment By

From: <Joel.Patterson_at_crowley.com>
Date: Thu, 22 Mar 2007 09:15:41 -0400
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B02BE0D31@JAX-MBH-01.crowley.com>


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-l
Received on Thu Mar 22 2007 - 08:15:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US