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