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 three
> databases (three different SIDs) to hold very few tables each. There is no
> problem of user restriction because virtually every user will have to have
> 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 databases.
>
> Many thanks in advance.
>
>
>
>
>

Danilo de Novais Silveira
danilo_at_dcc.ufmg.br Received on Fri Jan 11 2002 - 13:35:23 CST