Re: memory each instance is using

Steve Timko <steve_at_timko.com> wrote in message news:<3E418A6D.5040403_at_timko.com>...
> Ok, so what if you have several gigs of mem on a server with a few cpus
> that can easily handle a dozen or so instances for different
> purposes/projects?
>
> TCO?? 1-2 redundant brain boxes -- 20-30 small servers
>
> I'm am not a sr DBA by anymeans, however I need to say this has been
> working very well for us.. I'm interested in others thoughts to this
> setup? This is just development work.

It depends whether what you are doing can crash instances, generally pretty rare, and if you are using global synonyms, generally a bad idea. You probably want to do as Sybrand says, give each dev a schema. Probably the big hole with that is developers can write runaway stuff to blow up rollbacks (ie, use up all the RBS space, messing up everyone else), but hey, they're developers, that's a good thing, they'll learn to police themselves.

Give them each their own tablespaces for backup purposes. You do back them up, right?

If you have large read-only datasets, it may work better giving synonyms to the data rather than dblinks to another instance or many copies.

>
> -s
>
>
> Sybrand Bakker wrote:
> > On Wed, 05 Feb 2003 19:13:14 GMT, Steve Timko <steve_at_timko.com> wrote:
> >
> >
> >>I'm open for better ways of doing this type of setup?
> >
> >
> > Sure, get a seperate development and qa server.
> > The Oracle guideline is that the sum of all sga's shouldn't use more
> > than one third of physical RAM. In your case I wouldn't be surprised
> > if your server went pooooooooffffffff all of a sudden
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address

jg

--
@home is bogus
Would you believe I'm at my kid's elementar school posting this from a
@#@#$! MAC?  What a pile of cr....