Re: Tablesspaces and Datafiles - Max Sizes?

Big Al wrote:
>
> James Hanway wrote:
> >
> > Hi All,
> >
> > I'm looking at building a rather large database to hold ocean mapping
> > data, currently in v7.3.4, soon to be in v8.0.5 on a Digital UNIX box.
> > The idea is to keep a LARGE chunk of data from an even larger "off-line"
> > archive sitting on-line in a series of tables within a massive
> > tablespace. Sizes of close to 300-500 GIG on-line have been tossed
> > around.
> >
> > To date, I've never pushed the size of individual datafiles past 1000M,
> > which of course means 300-500 individual datafiles for that tablespace.
> > Anyone have any comments/thoughts on how large a datafile can *SAFELY*
> > be, and how many datafiles a given tablespace can have, and its
> > relationship to the MAXDATAFILE clause of the CREATE DATABASE command?
> >
> > Cheers!
> >
> > James
>
> A few comments. I don't know Digital UNIX, but on HP/UX you have a
> choice of 32 bit or 64 bit versions of the operating system and there's
> a 64 bit version of Oracle. This can make a difference. Secondly, we

Big difference. Digital Unix (also called Tru64 Unix) is 64bit. It's also very reliable and very fast. IMHO after using HP-UX for years, Tru64 is much better.

> have a ROT that says any multi table tablespace over 6 GB should be
> split into multiple tablespaces. This simplifies backup and recovery.

Backups are a pain, agreed. I have datafiles of over 5 GB and they function perfectly but take a while to backup.

> Also, the more datafiles
> you have the more work Oracle needs to do at each checkpoint to keep the
> SCN numbers in sync.
Received on Thu Sep 14 2000 - 08:05:43 CDT