We have a standard data file size of 2GB, If it is smaller (for some reason) we extend it but never > 2GB. If it is already 2GB, we add a new data file.
Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message----- Sent: Tuesday, July 16, 2002 10:53 AM To: Multiple recipients of list ORACLE-L 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----- 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.
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
