RE: AUTOEXTEND

  • From: "Powell, Mark D" <mark.powell@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 4 Oct 2005 16:08:10 -0400

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ora_forum
Sent: Tuesday, October 04, 2005 3:09 PM
To: oracle-l@xxxxxxxxxxxxx
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. 

Other related posts: