Re: Resizing Datafiles vs Adding Datafiles

From: Troy Meyerink <meyerink_at_edcmail.cr.usgs.gov>
Date: 2000/07/24
Message-ID: <397C4308.6F34D961@edcmail.cr.usgs.gov>#1/1

I would agree with your conclusion. Other OS limitations might come into play, like I know certain UNIX's have a 2GB file limitation size. I might need to 2GB datafiles for the same tablespace.

Troy Meyerink
Oracle DBA
Raytheon
Sioux Falls, SD
meyerink_at_usgs.gov

me wrote:

> When increasing the size of a tablespace you can either add a datafile or
> resize the datafile.
>
> What is the difference?
>
> Is there an advantage to one or the other?
>
> As far as I can tell the only advantage to adding a datafile to a tablespace
> would be performance and spreading the tablespace of more disks, but for
> small databases resizing the datafiles would seem more beneficial, less
> datafiles easier to manage.
>
> Any feedback on this would be great.
>
> Thanks for you time
>
> Lowell
>
> lfafard_at_cableregina.com
Received on Mon Jul 24 2000 - 00:00:00 CDT