Re: memory each instance is using

most of these are on a 8.1.7 ee

but I have a few on the same box using 806 and 816

-s

Steve Timko wrote:
> I have no objections to using 1-3 instances but we run several different
> projects using different software (bea, SAP, IBM, docu) which usually
> require different types of dbs whether its version conflicts (due to
> client specs) or chars set... or just that the project needs to start
> and stop and do wacky stuff to the instance. I didn't want to have all
> projects go down if one was doing some funky stuff. Along with
> deployment process of the scheme, code.. They always a want a dev and
> qa instance..
>
> I'm open for better ways of doing this type of setup?
>
> Can anyone pass along a good book or some sites that can help me how to
> maintain this type of setup, along with how to figure out the proper
> values for memory pools, etc...
>
> Thanks for all the support!!
>
> -steve
>
>
>
> DA Morgan wrote:
>

>> Steve Timko wrote:
>>
>>
>>> Problem:
>>>
>>> I have a 'brain' server running 15 instances for several different
>>> development projects on a 280r with 3 gig of physical mem.  I need to
>>> add a few more but only have about 80m of mem left.
>>>
>>> Questoin:
>>>
>>> What is the min amount of memory an instance can run with, and how would
>>> I view each instance use or cut it down.
>>>
>>> thanks
>>>
>>> -steve
>>
>>
>>
>> No mention of Oracle version and edition. Do you think this unimportant?
>> No mention of using Java. Do you consider the pool size unimportant?
>> No mention of current initialization parmeters. Do you consider them
>> unimportant?
>> No mention of the number of users, transaction sizes, etc . Do you 
>> consider
>> these unimportant?
>>
>> Personally I get queezy whenever anyone indicates more than three 
>> instances
>> on any server. Primarily because I don't think there is any rational
>> justification for creating instances when you can create schemas.
>>
>> Without a lot more information no one can give you an answer. But I'd be
>> merging the 15 you have rather than adding to the nightmare.
>>
>> Daniel Morgan
>>