Denham,
You haven't mentioned tablespaces. If all five datafiles are for one tablespace, it doesn't matter much. However if each datafile is for a separate tablespace, it would be easier to increase the size of the existing datafiles. Otherwise you would need to move objects to take advantage of the sixth datafile.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-----Original Message-----
From: Denham Eva [SMTP:[EMAIL PROTECTED]]
Hello Gurus
Which is the better policy:
Say you have five datafiles of 1GB in size each, now the total freespace is less than 10%.
Would it be wise to increase the datafiles to 2GB or would it be better for the system to add a sixth datafile?
Would appreciate any views on this point.
Rgds
Denham Eva
Oracle DBA
In UNIX Land
On a quiet Night, you can hear the Windows machines reboot.