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: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/14
Message-ID: <5ir70h$lhu$3@tst.hk.super.net>#1/1

Victor Lu wrote:

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

Be aware of this. You put a single DB to a distributed DBs, it could cost
a lot of careful consideration in doing so.

> 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 =
?

Only when two database is nearly totally independent and no freqrent data
interactions between two databases.

I suggest you first consider divide the application database into different schema. Received on Mon Apr 14 1997 - 00:00:00 CDT

Original text of this message

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