Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Size of database and new DB_NAME ???????
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