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@xxxxxxxxxxx>
To: <ganstadba@xxxxxxxxxxx>; <Oracle-L@xxxxxxxxxxxxx> 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@xxxxxxxxxxx x72546 904 727-2546 -- //www.freelists.org/webpage/oracle-l