better you keep autoextend so that you don need to wakeup in night only to add the space to tablespace / datafile. still u can control the size of Datafile. regards - chirag On 10/4/05, ora_forum <ora_forum@xxxxxxxxx> wrote: > > Hi All, > > I have consulting on site and he is trying to convince our management to > use AUTOEXTEND almost on all datafiles and monitor on FS. Could you give me > examples why we should not do AUTOEXTENTS? > > I'm thinking about: 1. Keep all db files 4 GB in size for better > maintenance... > > Something else? > Thanks. > > ------------------------------ > Yahoo! for Good > Click here to donate <http://store.yahoo.com/redcross-donate3/> to the > Hurricane Katrina relief effort. > >