Re: memory each instance is using

From: Steve Timko <steve_at_timko.com>
Date: Wed, 05 Feb 2003 19:13:14 GMT
Message-ID: <3E416250.3060309@timko.com>

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
>
Received on Wed Feb 05 2003 - 13:13:14 CST