Re: Optimal SGA for NT?

Whew! Why have 8 instances on one NT server? Aren't upgrades and maintenance an absolute nightmare? (For instance, you can't apply a patch to one without applying it to all 8, unless you running Oracle8 and have them setup in different Oracle homes.)

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Terry Dykstra wrote in message <36c08c1b.0_at_news.cadvision.com>...
>So what would you recommend when you have 8 instances on one NT server
>(768MB).
>
>--
>Terry Dykstra (TeamPS)
>Canadian Forest Oil Ltd.
>Marcus N Hofer wrote in message ...
>>if just the DB server, the TNS listener and nothing (remarkable) else
>>is running on the NT server, donīt hesitate and give 2/3 of the memory
>>to the SGA if the memory as such is bigger than 128 MB!
>>
>>I increased the SGA at a customers NT server(512MB) with heavy query
>>load from 1/2 to 2/3 of physical memory and retrieved a pretty good
>>performance increase.
>>
>>regards,
>>--marcus
>>
>>
>>skubiszewski_at_Eisner.DECUS.Org schrieb in Nachricht ...
>>>It seems to be common to size the SGA at 1/3rd of physical memory
>>>but is this true for Windows NT?
>>>
>>>What would you recommend as a "rule of thumb" for setting
>>>the SGA on an NT box?
>>>
>>>Thanks,
>>>
>>>Rose
>>
>>
>
>
Received on Wed Feb 10 1999 - 18:28:08 CST