RE: To create a new datafile or to increase a existing datafile.

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.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Denham Eva [SMTP:EvaD_at_TFMC.co.za]
>
> 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: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

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: ListGuru_at_fatcity.com (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).