RE: Auto Extend On, Increment By

From: <Joel.Patterson_at_crowley.com>
Date: Fri, 16 Mar 2007 11:30:35 -0400
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B02B7DB6D@JAX-MBH-01.crowley.com>

I agree. I was also thinking that UNDO would be analogous to TEMP.

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Steven K -
MSHA
Sent: Friday, March 16, 2007 11:10 AM
To: Oracle-L_at_freelists.org
Subject: RE: Auto Extend On, Increment By

I don't see the big downside of having autoextend on (except for temp tablespaces - those things can become a monster with a bad piece of code). At our shop, we use nagios to monitor the file systems. This helps prevent us from running out of space in the file system without having a tablespace fill up with a job in the middle of the night that I wasn't told was going to run. (kind of like having a GPS ankle bracelet on your teenager - right Tim?)

That said - I believe in monitoring to make sure that my space assumptions continue to be correct. If circumstances change because of a release of code or a change in the business model, then I can decide if I need to change my storage strategy.

Steve Smith

Desk: 303-231-5499

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams

	Sent: Thursday, March 15, 2007 6:00 PM
	To: Joel.Patterson_at_crowley.com
	Cc: Oracle-L_at_freelists.org
	Subject: Re: Auto Extend On, Increment By

	Joel,

	 

	If you decide to switch to autoextend, I think this is the least

issue to decide. The important issue is how space will be monitored. Done right, autoextend can give you a single space indicator to monitor. But make sure none of your tables have a limit of extents or you'll get a failure even though you still have disk space.

Dennis Williams

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

Received on Fri Mar 16 2007 - 10:30:35 CDT