My rule of thumb is 2gb or less for smaller databases, i.e. < 100gb and adjust higher for larger databases, e.g. 10gb datafiles for 1.3 tb database.
gene >>> [EMAIL PROTECTED] 07/16/02 11:28AM >>> 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
