| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: data files - How big?
There was a 2gb limit on exp/imp previous to 8.0.5.1. Oracle fixed them
with that patch.
Rodd Holman
Original Message dated 6/1/01, 11:53:54 AM Author: Jared Still <jkstill_at_cybcon.com> Re: Re: data files - How big?:
A general rule of thumb for many people is to not allow datafiles larger than 2Gb. You
will find many
variations on that theme ( some don't like files larger than 512Mb ) but the 2Gb limit
is due to possible
limitations in other software. You may run into trouble with backup software that
doesn't know how to
deal with files that large. I've heard reports that some of Oracle's utilities do not
always work
correctly with large files, though I can't recall any details on that. My system has a
2Gb datafile on
linux, and hasn't caused my any problems, but this is not a production system and
isn't stressed. ( or
backed up ) HTH Jared On Friday 01 June 2001 07:40, Barry Stubbs wrote: > I am setting
up a new linux
server (redhat 6.2 & oracle 8i 8.1.7) with a > 1Ghz Processor and 512Mb RAM. How large
should individual
data files in a > tablespace be allowed to grow? I can't find any advice on this in my
oracle >
manuals/books. Is there a data file size that starts to hurt oracle. I've > got one
tablespace that will
have 1-1.5 Gb of data. Should I allow a > datafile to grow to that size, or would
oracle like it better
if I split it > into 3 500Mb datafiles? Likewise, how should I handle the SYSTEM >
tablespace? Should I
leave it as 1 large datafile or should it be broken > into smaller ones? > I would
also like to know what
good oracle email lists are available to ask > dba related questions other than this
one. > > Thanks, > >
Barry Stubbs > Windham School District -- Please see the official ORACLE-L FAQ:
http://www.orafaq.com --
Author: Jared Still INET: jkstill_at_cybcon.com 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
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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). Received on Fri Jun 01 2001 - 13:52:14 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |