RE: Auto Extend

On Thu, 31 May 2001, Kevin Lange wrote:

> By the way ....... For your own sake ..... never use data files that big
> !! My personal opinion is multiple files of 500 Megs or less . Or, on a
> system that has a file limit, 1 GB files as a Max. Larger than that and
> you can have problems with backup software .... long running FTPs if you
> duplicate DBs ...etc.

Insisting upon such tiny file sizes is not practical in a large-scale enterprise environment. Systems I run on Compaq Tru64 Unix and HP-UX 11.00 (64 bit) routinely use 8 and 16 Gb. datafiles, with no problems or complaints from Veritas NetBackup. As for long-running FTPs, you have to move all the data, whether it is in a few files or many files. What does it matter if you have one FTP running for a long time, or many smaller ftps running, moving the same amount of data? Either way, you can probably achieve the appropriate degree of parallelism inthe transfer with just a few files to move.

I disagree with the statement that large file sizes should be avoided. What am I supposed to do, make a 6 terabyte warehouse out of 6000 tiny 1Gb datafiles? I can't even fit the initial extent for some segments into a 1gb datafile.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

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).