RE: Auto Extend On, Increment By

From: <Joel.Patterson@xxxxxxxxxxx>
To: <ganstadba@xxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
Date: Thu, 15 Mar 2007 15:07:04 -0400

Ok.   

Lets assume that all the datafiles will autoextend, (some may have
limits).  What determines the increment_by if anything?  I'm thinking
10Mbs.  That could waste space in a few files that rarely grow, but the
files would be remain fairly static once they extend.  The others can
grow at a reasonable rate.  I see files out there with 1 block increment
by, etc.

Perhaps a script or a query or a doc that someone uses? 

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

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael McMullen
Sent: Thursday, March 15, 2007 2:37 PM
To: Oracle-L@xxxxxxxxxxxxx
Subject: Re: Auto Extend On, Increment By

I very rarely use autoextend. We do lots of batch processing and
developers 
never put in deletes/archiving until they run out of space. It's also a
nice 
stop to a "runaway process" Or I might autoextend to a limit. Having
said 
that, the ones I do autoextend on base on the extent size of the
tablespace 
when using uniform extent sizes. For autoallocated extent sizes I use
64Mb 
as it used to be the largest extent size created with autoallocate
though I 
haven't checked with 10g. 

--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: Auto Extend On, Increment By
  - From: Michael McMullen

References:
- Re: Auto Extend On, Increment By
  - From: Michael McMullen

RE: Auto Extend On, Increment By

Other related posts: