Re: Are 5 Ora 7.3.3 Instances on 1 NT Box a good practice ?

Actually it's all a matter of perpective and "user expectations". We have 18 databases, whose average SGA is about 50MB, running on a single NT workstation (2 133 MHz processors, 1 GB RAM, 1GB pagefile) running Oracle 7.3.4 and, aside from the inevitable "queries from Hell", performance is not bad. I wouldn't recommend this configuration for life-or-death real-time nuclear facilities but, in a pinch, most NT servers can handle 5 instances.

Mike Morgan

Sybrand Bakker wrote in message
<945324597.3608.0.pluto.d4ee154e_at_news.demon.nl>...
>No, No, No
>The NT box will 100 percent most likely be unable to cope with the load,
>and ALL instances will suffer from this.
>In a 256M conf, 2 is maximum.
>
>Hth,
>
>--
>Sybrand Bakker, Oracle DBA
><rock_cogar_at_my-deja.com> wrote in message
>news:839a8m$s46$1_at_nnrp1.deja.com...
>> Hi,
>>
>> I have been asked to help people at a "sister" company move a production
>> Oracle 7.3.3 installation from a Denver NT server to an NT server in St.
>> Louis.
>>
>> It turns out that there are 5 Oracle 7.3.3 instances on the source
>> machine that each have the same single schema which is also the only
>> non-system schema. Of course there are minor differences, extra "load"
>> tables and different amounts of population in the "main" tables.
>>
>> QUESTION: Is having 5 Oracle 7.3.3 Instances on 1 NT Box a good practice
>> ?
>>
>> Thanks,
>> Rock Cogar
>> Email: rock_cogar_at_my-deja.com
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
>
Received on Thu Dec 16 1999 - 22:41:06 CST