"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message
news:csdlcd$eg2$1_at_news1.zwoll1.ov.home.nl...
> Mladen Gogala wrote:
> > On Sat, 15 Jan 2005 21:05:20 +0100, Frank van Bortel wrote:
> >
> >
> >>>anyway, it is strongly recommended that you control dbfiles sizes by
> >>>yourself, and not let them increase automatically.....
> >>>
> >>
> >>and why would that be? Lazy-DBA syndrome?
> >
> >
> > To protect the sanctity of marriage
> Fail to understand that one... I'd rather be home, have Oracle
> taking care of file growth, than being called at 2 in the morning
>
> and because dynamic allocation is
> > extremely costly, so the users can wait for unacceptably long time
> > during dynamic data extensions.
> >
> Hm - never had trouble with it, but yes, it could happen, when
> the chunks to grow with are large, and the (file-)system is
> heavily loaded. It is a point to be considered (isn't it all?)
> when using it; the size with with to grow should be reasonable.
>
> --
> Regards,
> Frank van Bortel
But being slow is better than being down. (eg the tablespace is out of room
vs the tablespace has to grow 250megs and takes 10 to 20 seconds)
Jim
Received on Sun Jan 16 2005 - 11:57:51 CST
