RE: Auto Extend On, Increment By

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_at_crowley.com
x72546
904 727-2546

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael McMullen Sent: Thursday, March 15, 2007 2:37 PM
To: Oracle-L_at_FreeLists.org
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.

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 15 2007 - 14:07:04 CDT