Re: Resizing Datafiles vs Adding Datafiles

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

Each has pros and cons...

Lots of files - good for spreading across lots of disks, but you might get bitton on checkpoints etc etc

Expand of files - good for simplicity, but you can hit some OS limits.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse