Re: When to use multiple instances on one server?

Advantages:

1. Independent shutdown/startup. Shutdown one applications database without affecting the other applications.
2. Independent tuning. Tune each database specifically for the application it supports.

Disadvantages:

1. Additional server resources (memory) required to support multiple instances.
2. SQL*Net. Have to create additional aliases and propagate them across the network. This may or may not be a big deal.
3. User accounts. Users may need multiple database accounts instead of one. Again, this may or may not be a big deal.
4. Backups and upgrades. Each database has to be done separately.

HTH BTINet News wrote:

> I am running one instance on Solaris 2.6 that has gotten very large (about
> 60 GB). This instance has about 10 applications that are fairly
> independant. I have been contemplating moving these apps to multiple
> instances.
>
> What would be the advantages and disadvantages of moving these apps to
> multiple instances?
>
> What criteria do you use to split apps into their own instances?
>
> Thanks,
> J
Received on Sat Aug 01 1998 - 15:43:07 CDT