Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Size of database and new DB_NAME ???????

Re: Size of database and new DB_NAME ???????

From: Robert Miller <rwmiller_at_gte.net>
Date: 1997/04/09
Message-ID: <5ig81e$s8q$4@news5.gte.net>#1/1

Victor Lu wrote:
> =
 

> Hi,
> =
 

> When an application is too large ( lots of data, intensive transactions=
 =85..),
> separate databases (identified by DB_NAME) need to be created.
> =
 

> My questions is:
> =
 

> How to determine when it is necessary to create separated Oracle databa=
 ses
> for different applications ? Especially during design stage, can we u=
 se
> predicted amount of data to decide whether we need a separate database =
 ?
> =
 

> Thanks
> =
 

> Vic

 =

Vic,

I always build a new instance for a new application. I was using an HP H70 for development with 3xx Meg of ram, and had about 6 small instances running supporting different development teams. Just keep the SID's small. The generic small example in every initXXXX.ora is a good starting point. Received on Wed Apr 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US