Got the overall the nitty on our ratio 15 Dbas in all
1 DBA : 200 Sqlserver databases :) ( Management loves that ratio) 10 DBA: 100 Unix Oracle Databases, 10 NT Oracle DB :) 4 DBA : 40 DB2 and 43 Teradata databases See that SQLSERVER Database ratio... show that to your boss.. make him sing Dixie. Bill was so dam smart...First he thinks of how to market the product then makes the product...who cares how the quality is..it will eventually get close. For those of you not familiar with SQLSERVER...basically each tablespace is called a database and every Tom, Dick and Harry gets in and creates a totally whacked out database. Brian -----Original Message----- Sent: Tuesday, March 11, 2003 4:29 PM To: Multiple recipients of list ORACLE-L 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: Spears, Brian 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).