Re: cost of autoextend

  • From: Gus Spier <gus.spier@xxxxxxxxx>
  • To: adar666@xxxxxxxxxxxx
  • Date: Mon, 15 Mar 2010 06:25:30 -0400

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@xxxxxxxxxxxx> 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.
>>
>>
>>  --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: