Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What's best - to resize datafiles or add new ones?

Re: What's best - to resize datafiles or add new ones?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 7 Jan 2003 22:11:58 -0000
Message-ID: <3e1c7455$2_2@mk-nntp-1.news.uk.worldonline.com>


"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E1B02C2.C27D0D8C_at_exesolutions.com...

> First time I've ever heard someone make the statement that there is an
> argument (good or otherwise) to make all datafiles the same size.
>
> I'd be interested in the issues as you see them.
>
> Thanks.
>
> Daniel Morgan
>
>

PMFJI. Niall may be referring to bigger databases, where for various reasons it may be advisable to restrict tablespaces to multiple files of (say) 2000M each. I for one would go along with that.

Regards,
Paul Received on Tue Jan 07 2003 - 16:11:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US