Re: Having 3-4 small databases on same server ?

We do. Each instance supports 3 - 5 different applications, each in it's own schema. Been working this way for several years. We are in the process now of moving toward 1 application per instance because of issues with recovery one application causing preformance issues for other applications in the same instance. We will probably end up somewhere in the middle with the less well behaved appliocations in there own instances and some applications sharing instances.

On Sat, 23 Feb 2002 17:04:44 GMT, "Ashish Mittal" <mittalashish_at_yahoo.com> wrote:

>If you are running the same version of Oracle, have you considered having
>different schemas on the same instance?
>"Mark" <mark_at_foxhillgroup.com> wrote in message
>news:3c77465a.17783651_at_netnews.attbi.com...
>> Christian,
>>
>> This isn't a problem at all. We have this setup on all our servers. In
>> our case we grouped the databases by application type (OLTP,
>> Reporting, etc.) and put all database of a particular type on the same
>> server. Our OLTP server currently has 15 instances with 4 ORACLE_HOMES
>> (7.3.4, 8.0.5, 8.1.6, and 8.1.7). This is a 12 CPU box with 8 GB of
>> RAM running Solaris 7.
>>
>> Hope this helps.
>>
>> Mark...
>>
>> On 21 Feb 2002 06:57:39 -0800, chse30_at_hotmail.com (Christian Svensson)
>> wrote:
>>
>> >Greetings all,
>> >
>> >We are about to consolidate 3-4 small databases into one (Unix)
>> >server. Before they reside on old Sparstation machines and we want to
>> >throw those out, about time...
>> >
>> >Are there any special things to be aware of besides:
>> >
>> >- We cant upgrade Oracle on just one of the databases, we have to take
>> >them all in one time. (am aware of multiple $ORACLE_HOME)
>> >- When the server have to reboot, all databases are affected
>> >- Careful sizing of SGA for the databases
>> >- Make sure that the server can stand up with the expected user load
>> >from all the databases
>> >
>> >Anyone know what Oracle says about this ?
>> >Are there any documentation about this ?
>> >
>> >Thanks for any comments on this.
>> >
>> >Regards
>> >
>> >Christian
>>
>
>
Received on Sat Feb 23 2002 - 17:29:01 CST