Re: DB architecture

Danilo is 100% correct. Distributed databases (even on the same machine) is not a design decision to be entered into lightly. The additional hardware resource consumption of multiple instances is a relevant issue, but much smaller than the performance risks and programming limitations introduced when using database links.

Brian Gastineau

Danilo de Novais Silveira <danilo_at_dcc.ufmg.br> wrote in message news:<Pine.GSO.4.21.0201111732500.27226-100000_at_turmalina.dcc.ufmg.br>...
> Hi,
>
> You're right. The most common way to use an Oracle DB is to have only one
> instance. In the instance, people build schemas to own tables. It isn't a
> good approach create many instances. Who create them is thinking link SQL
> Server. You will increase the performance if you put all tables in the
> same instance.
>
> Bye
> Danilo
>
>
>
> On Fri, 11 Jan 2002, G?y wrote:
>
> > Hi,
> >
> > Here is a question about the database architecture in Oracle. What is the
> > cost of having a database (and its service identified by its SID) running
 on
> > a machine. I am interested in knowing the cost of disk space and
> > computation.
> >
> > The problem is that someone has designed a system for us that requires th
 ree
> > databases (three different SIDs) to hold very few tables each. There is n
 o
> > problem of user restriction because virtually every user will have to hav
 e
> > access to all three databases (admitedly the system is meant to run with
 one
> > web user only).
> >
> > My view is that there should be only one SID running and all the tables
> > should be accessible under that service because it is more efficient for
 a
> > disk space and computational point of view. It is also an easier user
> > maintenance database approach. However, I am no Oracle expert, so I would
> > not mind a few views about the efficiency issues in running three databas
 es.
> >
> > Many thanks in advance.
> >
> >
> >
> >
> >
>
> Danilo de Novais Silveira
> danilo_at_dcc.ufmg.br
Received on Fri Jan 11 2002 - 22:56:56 CET