Re: cost of autoextend

From: De DBA <dedba_at_tpg.com.au>
Date: Tue, 16 Mar 2010 17:37:37 +1000
Message-ID: <4B9F3541.10609_at_tpg.com.au>

Exactly my point: autoextend merely moves the focus of attention from tablespace usage to filesystem usage. Snowing in or surf's up notwithstanding, the responsible DBA must still keep an eye out for the moment where space runs out. Same diff.

Cheers,
Tony

On 15/03/10 8:25 PM, Gus Spier wrote:
> Autoextend allows me to get sick, snowed in, or overwhelmed by
> user/management demands for attention. Even with autoextend, a DBA must
> monitor tablespace/data file usage to maintain situational awareness.
>
> f/r,
>
> Gus
>
> On Mon, Mar 15, 2010 at 1:20 AM, Yechiel Adar <adar666_at_inter.net.il
> <mailto:adar666_at_inter.net.il>> wrote:
>
> You are mostly right.
> I prefer to extend, rather then auto extend, my data files except
> for special cases.
>
> It is more troubling as I do not know of a tool that take into
> account both auto extend and the host file system and gives a
> warning that if you auto extent to the limit you will fill up the
> available space on the file system.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
>
> De DBA wrote:
>
> Auto-extend is just a feel-good marketing tool, imho.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Tue Mar 16 2010 - 02:37:37 CDT