Re: Size of an ORACLE Database over 100 Gb

From: Martin Douglas <dafis_at_ppp.test.jccbi.gov>
Date: 1996/10/04
Message-ID: <NEWTNews.844494718.10331.dafis_at_ppp.test.jccbi.gov>#1/1


In article <5334mp$hii_at_paris.magic.fr>, <mti-sales_at_magic.fr> writes:
> Path: news.ou.edu!news.ecn.uoknor.edu!news.wildstar.net!cancer.vividnet.com!hunter.premier.net!www.nntp.primenet.com!nntp.primenet.com!howland.erols.net!math.ohio-state.edu!jussieu.fr!univ-lyon1.fr!in2p3.fr!swidir.switch.ch!news.rccn.net!global-one.pt!rain.fr!magic.fr!usenet
> From: mti-sales_at_magic.fr (Vincent Vermot des roches)
> Newsgroups: comp.databases.oracle,comp.arch.storage
> Subject: Re: Size of an ORACLE Database over 100 Gb
> Date: Fri, 04 Oct 1996 22:52:35 GMT
> Organization: Magic OnLine
> Lines: 25
> Message-ID: <5334mp$hii_at_paris.magic.fr>
> References: <32361EA6.49AA_at_ratp.fr>
> NNTP-Posting-Host: ppp3-54.magic.fr
> X-Newsreader: Forte Free Agent 1.0.82
> Xref: news.ou.edu comp.databases.oracle:86104 comp.arch.storage:10025
>
> We can solve your problem immediatly
> with an Oracle scertified solution
> Please caontact MTI :
> WWW/mti.com
> or by phone : 717 970 0300
> or in France : mti-sales_at_sales.fr
>
>
>
>
> Alain BORGO <Alain.Borgo_at_ratp.fr> wrote:
>
> >We have a new application that use ORACLE 7. The total size of the database is about 250 Gb.
> >We certainly put all the files on 60 disks of 4 Gb each (perhaps we will use the RAID 5 technology).
 

> >The problem is to manage this very big database : particulary we fear for the administration of the data.
> >Another diffuclty is the time to save these 250 Gb.

 

> >We're wondering if someone had already manage such a big database or a so
 big volume of data.  

> >Anyone with some experience with that sort of problem will be welcome.
 

> >Alain BORGO.
>
>
>

Hi,

        I am working on a database that has 21gig of data and 26 gig of indexes. Some of my indexes are 2 gig. and some tables are 4 gig. I will add some new functionality soon which means that my 50 gig database per year might be as large as 75 or 100 gig per year. We have a one year old database and are just learning what problems you will encounter. Temp tablespaces must be large, exports will run days. imports will run weeks. Cold backups are a blessing but I would say for you to use and oracle backup at least once a month or periodicaly as time permits. my most recent problem is running a full export that is larger than one tape. The database is fast but administation is a nightmare.

        I would like to see other peoples comments.

Martin Douglas Received on Fri Oct 04 1996 - 00:00:00 CEST

Original text of this message