Re: Same vs. separate instance

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: Wed, 13 May 1998 18:57:21 +0200
Message-ID: <3559D0F0.5C9E5AAC@ubs.com>

Dag Arne Matre wrote:
>
> We are sometimes facing this situation:
>
> Install the DB for application B on the machine that runs the DB for
> application A. The applications are totally independent of each other. The
> question is whether to use the existing Oracle instance or create a
> separate.
>
> I guess there is no "correct" answer to this question, just a bunch of pros
> and cons for each solution, and the choice must be made after evaluating
> those for each situation.
>
> So, what are the pros and cons regarding backup/recovery, resource usage,
> ease of db admin, etc... Maybe someone can point me to some documents
> regarding this?
>
> TIA,
> D A

If the 2 Applications are completly independet. I would recommend two instances.
My reasoning:

1) You can start/stop/backup/restore the DB independet from each other.
2) You can tune each DB for its one requirements.
3) one disadventag is you have to split the memory for 2 instances (but

memory is today cheap ;-)
4) Ask yourself if this DB's have the same requirements for administration
(e.g. both are running with same Oracleversion). Is one a 24x7 system and the
other a 6hx5day system. What's the accepted downtime (1 application needs
restore and the other not and both are in the same instance).

All the questions, which you are asking about the DB must be asked about the
HW.

HtH
eugen Received on Wed May 13 1998 - 11:57:21 CDT