What datafile size is best?

From: Randi Wølner <randiwolner_at_hotmail.com>
Date: Thu, 18 Jan 2001 16:24:06 GMT
Message-ID: <GME96.352$P2.178993152@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:24:06 CST