Re: More than one database on a system? Was: need advice on filesystem layout

mccurdy_at_ucsvax.sdsu.edu (Mike McCurdy) wrote:

>This brings to mind a question that I have regarding several database
>systems that I will be consolidating to one AIX box. Our plan is to create
>one database and segregate the various applications by tablespace. Is
>there any reason to use multiple databases instead of one?

There are multible reasons for multible databases on one system:

1. if you are developing your own applications it is much easyer to use a PRODuction and a DEVelopment Database.
2. If you have different Appliactions which have nothing to do with the other, it will be easyer to administrate if they are in different databases. *) Upgrade one Application/DB will not desturbe the other Apps *) If the Appls are from different Vendors there will be no problem with secutiry and such things. *) Recovery of ONE Database, lets other DBs still work fine...
3. If you are a outsourcing company, you should use at least one database for each customer.

But there are also multibe reasons for using only ONE Database.

1. there is less overhead for multible SGA,...
2. It is less DBA work if you only have to manage on DB
3. If the Apps which are related together are in multible DB´s it force problems if one DB is down and the others are still running.

So it is depending on the need which solution is better.

regards
chris Received on Tue Jan 09 1996 - 00:00:00 CET