Re: What datafile size is best?

In my opinion, it comes down to what your data is like and manageability of the database. Smaller data files are (usually) easier to manage because you can move them around, perform concurrent backups, etc. But I had a case where one table was over 100 million rows, in which case a large data file containing just this table worked better because I wasn't constantly allocating more space.

As far as tablespaces, I would split the tables and indexes at least. I also prefer to put frequently used tables in multiple tablespaces so I can spread them across drives. Small, seldom used tables I typically lump together.

Just my opinion. A lot has to do with personal preference or data usage patterns. Neither of which have a standard answer.

"Randi Wølner" <randiwolner_at_hotmail.com> wrote in message news:GME96.352$P2.178993152_at_news.telia.no...
> Someone told me that I should rather have a number of "small" datafiles
 than
> to have one big.
> I have planned to have one datafile for a tablespace of 8 G (I use Oracle
> 8.1.5 for Windows NT - but will move
> to Unix platform soon).
> Should I instead have 4 datafiles of 2 G each, or 8 files of 1 G??
>
> And what about tablespaces - I have planned to keep alle my application's
> data in one tablespace (the one of 8 G),
> would it be better to divide them into more tablespaces?
>
> Can anyone give me some recommendation on what is best (and why)?
>
> Thanks a lot,
> Randi Wølner
>
>
Received on Thu Jan 18 2001 - 10:38:19 CST