Re: DB architecture

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 ry 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 - 20:35:23 CET