RE: AUTOEXTEND

I think auto-extend datafiles are a very bad idea. I do not know how many posts I have read in the metalink forum where some poor dba used the feature only to end up with no space left on the disk. Usually the rollback (now undo), temp, or system tablespace seems to be involved. Once or twice it has been a user data tablespace where development managed to place code with an insert in an infinite loop into production.  

Usually the poster wants to know why "shrink" does not work.  

The fact remains it is the job of the DBA to monitor the database space usage and to configure the database to support the applications and user load. Each tablespace needs to be a certain size and if it should attempt to extend beyond that size something is wrong or has changed. The DBA need to be aware of all major data loads and changes to how applications will interface with the database. Development is responsible for informing DBA of their activity.  

When Oracle first introduced extendable datafiles the word was the feature was introduced for small shops that did not have a fulltime or real DBA. If can be useful if you do not know how big something will be, but the feature is dangerous and has caused many a DBA hours of work reallocating tablespace usage.  

The feature is a crutch for lazy DBA's who do not want to perform trend analysis on the database space usage and who do not keep themselves informed of development plans.  

IMHO -- Mark D Powell --  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ora_forum Sent: Tuesday, October 04, 2005 3:09 PM
To: oracle-l_at_freelists.org
Subject: AUTOEXTEND

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.

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