Re: Resizing of Data Files - How Long SHOULD It Take?

Because large monolithic datafiles have to be backed up in their entirety; they have to be restored in their entirety; and they have to be recovered in their entirety.

Plus, they only live on one disk, which means you are foregoing Oracle's normal striping and I/O distribution mechanisms. Striping effects are good for performance. Large single files kind of counteract that.

There are other reasons, but those are the main ones.

Regards
HJR "Lusiana Lusiana" <lusiana_at_nortelnetworks.com> wrote in message news:ad1rf2$m3f$1_at_bcarh8ab.ca.nortel.com...
> Newbie question:
> What is the reason behind the 2Gb datafile size and not to resize
datafiles
> ?
>
> Lusiana
>
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:ad0t42$b2l$1_at_lust.ihug.co.nz...
> ...
> > My usual rule of thumb: stick to 2Gb tablespaces, and increment as
needed
> by
> > adding in 2Gb datafiles. Never resize a thing.
>
>
>
Received on Wed May 29 2002 - 03:11:03 CDT