Re: ORACLE INSTANCES PER DBA

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Nov 2002 08:35:04 -0800
Message-ID: <2687bb95.0211190835.4315902b@posting.google.com>

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 - 10:35:04 CST