We have autoextend on but we limit the amount it grows to so we don't fill up the filesystem We also have a job that monitors the filesystem anyway just in case. K --- On Sat, 3/13/10, Howard Latham <howard.latham@xxxxxxxxx> wrote: From: Howard Latham <howard.latham@xxxxxxxxx> Subject: Re: cost of autoextend To: joe_dba@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Date: Saturday, March 13, 2010, 1:48 PM When your disk is full you weep! Often helpful developers will turn this on for you! On 13/03/2010, Joe Smith <joe_dba@xxxxxxxxxxx> wrote: > > How do you measure the cost of a datafile autoextending? > > > > thanks. > > > > > > > > _________________________________________________________________ > Hotmail: Trusted email with powerful SPAM protection. > http://clk.atdmt.com/GBL/go/210850553/direct/01/ -- Howard A. Latham -- //www.freelists.org/webpage/oracle-l