RE: POLL: Database to DBA ratio

I'd twelfth (or whatever number we are upto by now) the comments so far on how it isn't a fair measure. For what its worth we now have 19 Oracle instances and 7 sql server databases, probably 50+ schemas. You can take your pick as to what you mean by database. We have 3 dbas. One thing that does complicate this is that most of the databases get there own server because of the slightly mad project driven way budgets work (like there is no budget for database servers but each team will have a budget for software and hardware).

Sometimes it seems really quiet and stereotypically govt overmanned, othertimes I don't see my daughter awake for a week at a time. What would I say adds to demands on time/efficiency

Rate of change of db
Number of managers interested in using you as a resource Number of servers
Uptime requirements
Rate of development

Niall

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of
> Chuck Hamilton
> Sent: 11 March 2003 21:29
> To: Multiple recipients of list ORACLE-L
> Subject: Re: POLL: Database to DBA ratio
>
>
> You are the first reply out of at least 20 (public and
> private) who has a larger ratio than we do. The average seems
> to be somewhere around 20 so far. As many have pointed out,
> there are other factors to be considered if you're trying to
> measure the DBA's workload. I'm not trying to be that precise
> though. The DB to DBA ratio is close enough for me.
>
> BTW in case anyone is interested we have 2 DBAs managing 66
> databases. 25 are dev/test. 41 are production. Of the 41, 39
> are 24x7, 6 are over 100g, one is over 1000g. These #'s are
> more accurate that what I reported off the top of my head to
> a few in private.
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, March 11, 2003 1:31 PM
>
>
> >
> > Consider yourself lucky. We've got a 71:1 ratio here.
> >
> >
> >
> > "Chuck Hamilton"
> > <chuckh_at_softhome.net> T
> > To: Multiple
> recipients of list ORACLE-L
> > Sent by:
> <ORACLE-L_at_fatcity.com>
> > root_at_fatcity.com cc:
> >
> > bcc:
> > Subject:
> POLL:
> > 03/11/03 09:59 AM Database
> to DBA ratio
>
> > Please respond to
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> > I'm trying to build a case for management that we need
> additional DBAs
> > so I'd like to take a quick poll if I may. What is the
> ratio of Oracle
> > databases to DBAs in your shop? This includes development and
> > production databases. At our shop it's 33:1.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Chuck Hamilton
> > INET: chuckh_at_softhome.net
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from). You may
> also send
> > the HELP command for other information (like subscribing).
> >
> >
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> > INET: DEEDSD_at_Nationwide.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > name of mailing list you want to be removed from). You may
> also send
> > the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chuck Hamilton
> INET: chuckh_at_softhome.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Niall Litchfield
  INET: niall.litchfield_at_dial.pipex.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).