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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > Sent: Tuesday, March 11, 2003 1:31 PM > > > > > > Consider yourself lucky. We've got a 71:1 ratio here. > > > > > > > > "Chuck Hamilton" > > <[EMAIL PROTECTED]> T > > To: Multiple > recipients of list ORACLE-L > > Sent by: > <[EMAIL PROTECTED]> > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
