Re: ORACLE INSTANCES PER DBA

I agree with Mark, the idea of 1000 or more instances seems odd... Perhaps 100 instances with 10 schemas each , or 10 instances with 100 schemas,
but seldom have I seem a need for 1000 instances ( what kind of hardware are you under/over using?)

Are the needs of the various users so different that separate instances are really required ?

Just my 2c

Mark.Powell_at_eds.com (Mark D Powell) wrote:

>Ed Blondin <apgm26_at_email.mot.com> wrote in message news:<3DD9C2E7.3526AA9B_at_email.mot.com>...
>> I am working for a company that is trying to determine how many DBA's
>> should we reasonably have for a large environment (1000 different
>> instances). There is no one answer here and different instances take
>> different amounts of work. I was just trying to see where we fit in the
>> DBA arena. We currently have a ratio of about 22 instances per DBA. We
>> have no idea if there is an industry norm or if we have more or less
>> instances per DBA. Can anyone help?
>
>Ed, it all depends on the work required and expected. I would be more
>interested in answering the question, do we really need 1,000
>instances?
>
>Just applying the upgrade scripts is a pretty time consuming task with
>so many databases to keep current. That is assuming they need to be
>kept current. You haven't really provided any useful information
>about what the databases are used for or how they were set up so I say
>it is impossible to give you a useful answer.
>
>HTH -- Mark D Powell --
Received on Tue Nov 19 2002 - 11:23:01 CST