Re: How many of you run multi apps in one instance?

rtproffitt wrote:
>
>
> Hello all,
>
> I came from a large company which had the
> luxury of the ideal world. We had many
> Unix servers running one instance per server.
> Regardless of Test or Production or Training
> etc. there was generally one application/system
> running within one instance.
>
> Now I am in a company that for management,
> financial, and historical reasons (going back
> to 70's and 80's), we are running a couple
> servers with instances which have many applications
> running...in some cases 6 or 7 or 8 completely
> separate systems all running in one instance...
> While I disagree with this approach, I cannot
> fight the decision making of top management...
>
> I was just wondering about all you other folks,
> under what conditions you are running,
> whether you also have multiple apps in single
> instances, and what your experiences have been.
>
> Thanks Much,
> Robert Proffitt
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Just from experience I can say it depends on the needs of the applications.  If you have 5 query only applications and only 1 update intensive application this scenario may work fine. Of course it also depends on the horsepower of the machine and network that you have Oracle running on. Generally we run one instance for development / one for testing one for production etc. We don't partition them according to the application because our systems can generally handle the load all our applications require (I work for a consulting firm). We are generally more concerned with keeping our ENVIRONMENTS separate then separating out applications which can be done by having each application live in a separate schema. Yeah in a perfect world I'd love my own instance, but we all know you have limitations in hardware(memory), finances ($$$) etc. So unless performance is really bad at your site I would worry as long as the applications are partitioned logically.

HTH
RC

--
Posted via CNET Help.com
http://www.help.com/ Received on Wed Jan 05 2000 - 15:30:17 CST