Re: DB architecture

Your instincts are good. I can not imagine any rational reason for three SIDs other than a multi-terabyte system which is unlikely to be what you have. The conclusion I immediately draw is that the architect should refund your money and that you should retain someone that actually understands Oracle. Likely they made many many more horrible errors in judgment.

Daniel Morgan

"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.
Received on Fri Jan 11 2002 - 07:25:25 CST