Re: ORACLE DBA'S PER INSTANCE???

Ed Blondin <apgm26_at_email.mot.com> wrote in message news:<3DD9C2A8.EE1A7BA1_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?

There is no norm, because as a metric, instance/DBA is so variable. Also, across sites, the definition of "DBA" changes. I've seen a single instance be overwhelming, and a single DBA handle dozens. Besides what everyone else mentioned, it varies based on where in the life cycle each application resides. An organization with 1000 instances is likely to have great variability as to the workload and expectations of its own DBA's. Such an org is likely to have many mature (and perhaps "behind the support curve") apps, with lots of cans of worms that no one may even know about.

Try asking your DBA's to quantify how much more staff they would need to do things properly in an ideal world.

jg

--
@home is bogus.
http://www.garry.to