Re: DB architecture

Hi,

Your right, just one SID will be perfect for you, the only time you have to use more then 1, is when you have just 1 server and you want to have OLTP and DSS system on the same machine. Because each instance need different setup.

And if its for a web server, you have to use just one account to access your DB. So it will be more easy for your programmer, and your developpment server can be smaller then the prod machine.

hth
Chris
(Sorry for my poor english ;-) )  

"G?y" <ducateg_at_info.bt.co.uk> wrote in message news:<a1mqbj$ksa$1_at_pheidippides.axion.bt.co.uk>...
> 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 Tue Jan 15 2002 - 15:35:26 CST