Re: Two instances?

Thank you for all your thoughtful and helpful replies.

In my limited (but growing) knowledge of Oracle, I tended to think that, most of the time, multiple instances would be less desirable than multiple schemas. But, in the proposed situation I describe, I was thinking along the lines that Mr. Harris expressed...

>IMO, the most significant statement you've made is "There will be separate
>administration with possibly separate DBAs". Potential for differing
>performance management, differing backup/recovery management, possibly
>differing patch/upgrade needs. I'd use separate instances.

Just perhaps, in this case, to accomodate maximum independence, maybe even distinct installs??

From the several responses, I appreciate that there may be other, extra-technological factors that apply. These need to be considered. The two parties that I reference are government agencies so we'll probably consult our extensive legal resources for further, non-technical advice on the host of issues this and other threads suggest.

However, just for the sake of a technical discussion, may I refocus the question, please. Is there significant overhead involved in creating a second instance (vs. just adding schemas)? Temporarily setting aside non-technical issues, how would you evaluate (vmstat, for example?) the ability of existing CPU resources to absorb a second instance?

"David & Sarah Grove" <dg_at_ieee.org> wrote in message news:11aqgnp7s38v0df_at_corp.supernews.com...
> Folks,
>
> Consider a single machine (Sun V480/Solaris 10) running Oracle 10g. Two
> parties are interested in cooperating (one brings the machine, the other
> brings the Oracle license). Disk space (>500 GB) is more than enough for
> both. Memory (16 GB) is more than enough for both. There are no common
> users. There are no common applications. There are no common schemas.
> There will be separate administration with possibly separate DBAs. Each
> party will have several schemas (total of 10 - 20 schemas). Three of one
> party's schemas each have in excess of 1000 tables and 1000 stored
> procedures.
>
> We are considering whether to just put both parties schemas together in a
> single instance, or, perhaps, make two instances.
>
> Might I be able to determine from vmstat whether there is sufficient
> "headroom" in cpu usage for a second instance? In other words, if I get
one
> of the parties set up, can I use vmstat to determine whether, assuming
> everything else is adequate, there is enough horsepower to bring the
second
> party in as a second instance?
>
> Thanks for any thoughts.
>
> DG
>
>
Received on Mon Jun 13 2005 - 12:43:21 CDT