Re: Auto Extend On, Increment By

How about querying dba_extents and looking for the max extent size for each tablespace. Assume that it is your biggest tables wishing to extend and use that as your autoextend. But, are you using uniform extents sizes? If so, that should be your autoextend.
----- Original Message -----

From: <Joel.Patterson_at_crowley.com>
To: <ganstadba_at_hotmail.com>; <Oracle-L_at_FreeLists.org> Sent: Thursday, March 15, 2007 3:07 PM
Subject: 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

--

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