RE: POLL: Database to DBA ratio
Title: RE: POLL: Database to DBA ratio In our environment, each DBA supports a certain number of databasesthat are his/her 'primary' databases (all the way from Test/Dev/Accept/Production). The same person is 'secondary' or 'tertiary' for others.We follow a standardizedsetup (somewhat modified OFA) for *all* of these databases, with standardized, but different, passwords for sys/system/production schema accounts that can be easily 'figured out' by DBA team members.Those arechanged routinely!All DBAs are on call all of the time. Every 2 hours the automated pagingmechanism/Operations is made 'aware' of who's available via our own DBA Web App, that keeps track of who's in and who's out as well as the 'primary','secondary','tertiary' matrix by databasenames. This is working great for over 5years now - Kirti -Original Message-From: Chuck Hamilton [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 6:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: POLL: Database to DBA ratio With such a large # of databases to support, how do you divide up the work? Does everyone administer all of the databases, or are databases assigned to a DBA? How do you handle on-call? - Original Message - From: Adams, Matthew (GECP, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 2:40 PM Subject: RE: POLL: Database to DBA ratio 350 Oracle Databases spread across US and Europe. 14 full time, 4 part time. 75% of applications are designed and built in-house. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio We have over 400 databases, 90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter - Kirti -Original Message- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time.
RE: POLL: Database to DBA ratio
Depends on what you consider to be 'real' production issues. We get pages for production and development, for things that really should be planned change control, for idiot user stuff, as well as the regular db/listener down, ora-0600 and the other standard stuff. With most of the applications being developed in-house by folks that don't really know anything about how Oracle really works, probably 60% is fire-fighting. It's a lot better than it used to be however... We had a reorg three years ago that split the then-DBA group into two sides - Plan/Build, and Run. The Run folks were solely responsible for the pager. Consequently, all of the Run folks quit right after I came on staff. So, for 6 months or so it was me and two Sybase guys who were hired shortly after me and did the crash-course route into Oracle. That was brutal. Spears, Brian [EMAIL PROTECTED] T com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] bcc: Subject: RE: POLL: Database to DBA ratio 03/12/03 04:09 PM Please respond to ORACLE-L Are those pages real production issues? How much is fire fighting work? Brian -Original Message- Sent: Wednesday, March 12, 2003 3:04 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. Chuck Hamilton [EMAIL PROTECTED]T To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: Subject: Re: POLL: 03/11/03 04:29 PMDatabase to DBA ratio Please respond to 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
RE: POLL: Database to DBA ratio
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 AMDatabase 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
Re: POLL: Database to DBA ratio
We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. Chuck Hamilton [EMAIL PROTECTED]T To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: Subject: Re: POLL: 03/11/03 04:29 PMDatabase to DBA ratio Please respond to 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 AMDatabase 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
RE: POLL: Database to DBA ratio
We have over 400 databases, 90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter - Kirti -Original Message- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
RE: POLL: Database to DBA ratio
Title: RE: POLL: Database to DBA ratio 350 Oracle Databases spread across US and Europe. 14 full time, 4 part time. 75% of applications are designed and built in-house. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio We have over 400 databases, 90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter - Kirti -Original Message- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
RE: POLL: Database to DBA ratio
Title: RE: POLL: Database to DBA ratio We have 4 production Oracle databases and 3 DBA's. Of course, we have additional duties as well. I spend many afternoons out at the airport as a baggage handler for Horizon Airlines. --Walt Weaver Bozeman, Montana -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio We have over 400 databases, 90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter - Kirti -Original Message- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
Re: POLL: Database to DBA ratio
We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. Chuck Hamilton [EMAIL PROTECTED]T To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: Subject: Re: POLL: 03/11/03 04:29 PMDatabase to DBA ratio Please respond to 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 AMDatabase 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
RE: POLL: Database to DBA ratio
Title: Message Not mention the afternoons at Big Sky and Bridger working as a ski run quality assurance tester! ; ) Rick Weiss -- Helena, Montana We know better -Original Message-From: Weaver, Walt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 12:51To: Multiple recipients of list ORACLE-LSubject: RE: POLL: Database to DBA ratio We have 4 production Oracle databases and 3 DBA's. Of course, we have additional duties as well. I spend many afternoons out at the airport as a baggage handler for Horizon Airlines. --Walt Weaver Bozeman, Montana -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio We have over 400 databases, 90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter - Kirti -Original Message- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
Re: POLL: Database to DBA ratio
Well, I'll add my $00.02 worth. I have about 15 databases, more or less. It varies depending on what's going on. Right now it's more. :) They are on NT, Win2k, Solaris and Linux. Sizes range from a few gig to 450 gig. In addition, I own IT change control ( Oh joy ), and a few other goodies. Enough to keep me busy. Jared Chuck Hamilton [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/11/2003 06:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:POLL: Database to DBA ratio 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).
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: [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 AMDatabase 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
RE: POLL: Database to DBA ratio
Are those pages real production issues? How much is fire fighting work? Brian -Original Message- Sent: Wednesday, March 12, 2003 3:04 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. Chuck Hamilton [EMAIL PROTECTED]T To: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: bcc: Subject: Re: POLL: 03/11/03 04:29 PMDatabase to DBA ratio Please respond to 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 AMDatabase 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
RE: POLL: Database to DBA ratio
FWIW... There is no fair measure in my opinion. It depends on how well a model environment was set up in the first place for each database instance. A first class model environment needs less maintenance in general than a hack environment. You spend much less time in break/fix mode as a result and more time in optimizing/tuning for zero administration (shameless plug - Live 2003 - White Paper Presentation - Where there's smoke there's fire... Firefighter or Arsonist) Many times we are our own worst enemies and unintentionally trap ourselves into break/fix mode 7X24. On the other hand, sometimes you inherit these environments and there is no alternative but break/fix because there is no time. All of that having been said, here's some thoughts... 1. Use any off the shelf software to help you build a model environment which includes lights out proactive monitoring that you are comfortable with. 2. Ditto for backup software 3. Where you can't use off the shelf software, use the minimum number of scripts possible to help you manage your database and provide critical email alerts daily for non-critical maintenance and only send pages for critical failures about to happen. 4. Keep a detailed workbook of every utility script. If you wrote it once, you will probably need it again so why not save it and document it for later use. 5. Make EVERY database environment as close to identical in OFA layout as possible. I've run teams where the ratio is over 100:1 and they run like a swiss clock because of excellent planning and execution. I've also been in shops where 4:1 was nearly impossible because the initial setup and on going configuration of every database is completely different and no consistent implementation of installation, configuration, monitoring and maintenance is in place. In the 4:1 shops... my primary goal was to get the shop to a consistent configuration in a minimalist mode at first and then evolve the more sophisticated monitoring and tuning aspects of the environment. Don't know if this helps. If not, find me at Live 2003 and let's talk. Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com International Oracle Users Group www.ioug.org Board of Directors Elect - 2003-2005 Board of Directors - 2000-2002 University Master Class Faculty 2001-2002 Oracle Development Tools User Group www.odtug.com Board of Directors 1996-2000 -Original Message- Sent: Wednesday, March 12, 2003 3:14 PM To: Multiple recipients of list ORACLE-L 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 AMDatabase to DBA ratio
Re: POLL: Database to DBA ratio
Title: Message Damn. Beat me to the punch. I was going to mention being a "snow quality" inspector or Blue Mountain (PA). :-) - Original Message - From: Weiss, Rick To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 3:19 PM Subject: RE: POLL: Database to DBA ratio Not mention the afternoons at Big Sky and Bridger working as a ski run quality assurance tester! ; ) Rick Weiss -- Helena, Montana We know better -Original Message-From: Weaver, Walt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 12:51To: Multiple recipients of list ORACLE-LSubject: RE: POLL: Database to DBA ratio We have 4 production Oracle databases and 3 DBA's. Of course, we have additional duties as well. I spend many afternoons out at the airport as a baggage handler for Horizon Airlines. --Walt Weaver Bozeman, Montana -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio We have over 400 databases, 90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter - Kirti -Original Message- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
Re: POLL: Database to DBA ratio
Title: RE: POLL: Database to DBA ratio With such a large # of databases to support, how do you divide up the work? Does everyone administer all of the databases, or are databases assigned to a DBA? How do you handle on-call? - Original Message - From: Adams, Matthew (GECP, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 2:40 PM Subject: RE: POLL: Database to DBA ratio 350 Oracle Databases spread across US and Europe. 14 full time, 4 part time. 75% of applications are designed and built in-house. -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 12, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio We have over 400 databases, 90%+ are Oracle under various versions, platforms. Today have 19 DBAs. Two weeks from now there will be 17. Rightsizing to continue in the 2nd Quarter - Kirti -Original Message- Sent: Wednesday, March 12, 2003 12:09 PM To: Multiple recipients of list ORACLE-L We have 7 DBAs. 105 production databases (97 24x7), ranging from 2 GB OLTP to 800 GB data warehouses. 395 devl/alpha/beta databases ranging in size from very small (1 GB) to production-sized. About 1/3 of the production databases have at least 1 (usually more) development effort going on at any given time. Most of our time (lives?) is spent just keeping things up and running. The on-call guy averages between 50 to 100 pages per week (record is in the 230-range). Tuning and testing new stuff is fairly uncommon - as we have time. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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).
RE: POLL: Database to DBA ratio
Title: RE: POLL: Database to DBA ratio In my shops we use a similar matrix to this for management and assignment. In short, on-call rotates weekly and the "on-call" responsibility covers non business hours (eg: 7pm - 8am). The remainder of the time the environment DB owner has responsibility. The (A) indicates an automated process, each DBA has designated databases for all management during normal business hours. The on-call DBA handles off-hours work. The matrix is as wide as you have database instances. Here's an example from an environment I worked on. The script name column is the exact path/name for the script supporting automated functions, or, the name of the script to manually check stuff. Instance Management Checklist ER DAILY CHECKLIST SCRIPT NAME · Verify successful logon to database (A) · Verify Listener is up (A) · Verify NAMES Server is up (A) · Review Alert log for errors (A) · Review Free-Space report · Review 10-or-more-extents report · Identify Objects Unable To Throw Next Extent (A) · Verify archiving of redo logs · Verify archived logs being moved to staging area correctly · Verify staged archived logs are being moved to tape · Check for Invalid objects (A) · Check for Changed objects (A) · Check for File System usage thresholds (A) · Check for Tablespace usage thresholds (A) · Check for Tablespace Autoextend usage thresholds (A) · Check Analyze for Corrupt Segments report (A) · Check Pricing Refresh Group Incomplete report (A) · Trim Otrace files (A) · Check MLOG$ vs. SNAP$ Inconsistency report (A) · Purge old leftover rows from snapshot logs (A) · Check for Snapshot Refresh errors (job failures) (A) · Verify successful run of nightly exports (A) · Verify that build_customer_product ran successfully (A) · Verify that Usage Billing ran successfully (A) FRIDAY CHECKLIST · Purge log and trace files (DO FOR TRACE FILES) (A) · Review Row Chaining report · Review hit ratios (OEM Performance Pack, summary data) · Review Actual Segment size report and resize as necessary · Review Table statistics report · Review Redo Latch statistics report · Review Rollback Segment storage report · Review Rollback Segment statistics report MONDAY CHECKLIST · Verify that weekly analyze ran successfully (A) · Verify that build_contract_prod_price ran successfully (A) SEMI-MONTHLY CHECKLIST (15th + 30th) · Run bmark performace monitoring script · Review script in detail for potential problems · Provide written status and analysis of bmark output · Prepare scripts to tune instance after acceptance of bmark recommendations by dba group · Execute tuning scripts for instance (A)=Automated - See DBA Common Scripts, - = Not Applicable Regards, Bill Burke "The Kinder and Gentler DBA" www.OracleGuru.com International Oracle Users Group www.ioug.org Board of Directors Elect - 2003-2005 Board of Directors - 2000-2002 University Master Class Faculty 2001-2002 Oracle Development Tools User Group www.odtug.com Board of Directors 1996-2000 -Original Message-From: Chuck Hamilton [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 6:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: POLL: Database to DBA ratio With such a large # of databases to support, how do you divide up the work? Does everyone administer all of the databases, or are databases assigned to a DBA? How do you handle on-call? - Original Message - From: Adams, Matthew (GECP, MABG, 088130) To: Multiple recipients of list ORACLE-L Sent: Wednesday, March 12, 2003 2:40 PM Subject: RE: POLL: Database to DBA ratio 350 Oracle Databases spread across US and Europe. 14 full time, 4 part time. 75% of applications are designed and built in-house. -Origin
Re: POLL: Database to DBA ratio
Chuck, At this location we have a total of 5 databases and 1 DBA. Time off without an electronic teather is a thing of the past. My last location was 4 production databases with 1 DBA and a backup DBA from the development arena of 2 development databases and 1 DBA. Ron [EMAIL PROTECTED] 03/11/03 09:59AM 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: Ron Rogers 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).
RE: POLL: Database to DBA ratio
3:1 Production, Development, my personal test DB : Me Craig Healey -Original Message- From: Chuck Hamilton [mailto:[EMAIL PROTECTED] Sent: 11 March 2003 14:59 To: Multiple recipients of list ORACLE-L Subject: POLL: Database to DBA ratio 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. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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).
RE: POLL: Database to DBA ratio
33 DBA's to one database? That's pretty danged good! :) Seriously, this is a question that comes up every so often within Oracle as well, as clients ask Oracle employees what should be expected. There's no simple answer to it. As you might expect, the answer is it depends. :) Depends on (a non-exhaustive list): 1. Requirement for 24x7 DBA coverage 2. Complexity of database 3. Type of applications using the database 4. Database type (OLTP, DW etc.) 5. Number of tiers (two tier, three tier etc.) 6. Amount of input required into development of apps (tuning support and so on) And lots more as well. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Hamilton Sent: Tuesday, March 11, 2003 6:59 AM To: Multiple recipients of list 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: Pete Sharman 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).
Re: POLL: Database to DBA ratio
We have 10 development databases that I support directly plus 5 implementation/testing databases that I support as second level and one production snapshot datamart. 16:1 However, there are also DBAs who support each project. That would make the ratio closer to 4:1 or 3:1. Chuck Hamilton chuckh To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @softhome.net cc: Sent by: rootSubject: POLL: Database to DBA ratio 03/11/2003 09:59 AM 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: Thomas Day 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).
RE: POLL: Database to DBA ratio
27 databases to 1 dba, mixed dev, test, and prod. [EMAIL PROTECTED] 03/11/03 11:29AM 3:1 Production, Development, my personal test DB : MeCraig Healey -Original Message- href="">mailto:[EMAIL PROTECTED] Sent: 11 March 2003 14:59 To: Multiple recipients of list ORACLE-L 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. **This email and any files transmitted with it are confidential and intended solelyfor the use of the individual or entity to whom they are addressed and may containconfidential and/or privileged material. Any review, retransmission, disseminationor other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statementsand opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeperfor the presence of computer viruses (www.mimesweeper.com)***-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Craig Healey INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: POLL: Database to DBA ratio
Chuck I think this is a slippery argument. It may appeal to managers but can lead to bad decisions long-term. Does anyone remember years ago when managers would measure COBOL programmers LOC (lines of code)? Just measure how many lines of code each programmer writes each day and vola! you know which are your best programmers -- right? But I would match 5 production instances against a single test instance with a group of cranky developers who are normalization bigots. I maintain about 15 instances by myself, so by your standards I'm a real slacker. I've tried to group applications into common instances, for ease of maintenance and better use of system memory. Maybe I should change that policy so I can boost my numbers ;-) Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 11, 2003 8:59 AM To: Multiple recipients of list 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: DENNIS WILLIAMS 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).
RE: POLL: Database to DBA ratio
[EMAIL PROTECTED] 03/11/03 09:59AM 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. It fluctates pretty wildly for us depending on the RD effort at any one point in time. But it's not unusual for us to have 50:3, though the 50 are of mixed types (Oracle, DB2, SQLServer etc.) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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).
RE: POLL: Database to DBA ratio
6:2 six DBAs to one development + one testing VLDB. Good luck. -Original Message- Sent: Tuesday, March 11, 2003 11:29 AM To: Multiple recipients of list ORACLE-L 3:1 Production, Development, my personal test DB : Me Craig Healey -Original Message- From: Chuck Hamilton [mailto:[EMAIL PROTECTED] Sent: 11 March 2003 14:59 To: Multiple recipients of list ORACLE-L Subject: POLL: Database to DBA ratio 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. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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: Dong, Ping - Raleigh, NC 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).
RE: POLL: Database to DBA ratio
volume of database structural changes (new tables, changes to existing ones) is another to add to that list --- Pete Sharman [EMAIL PROTECTED] wrote: 33 DBA's to one database? That's pretty danged good! :) Seriously, this is a question that comes up every so often within Oracle as well, as clients ask Oracle employees what should be expected. There's no simple answer to it. As you might expect, the answer is it depends. :) Depends on (a non-exhaustive list): 1.Requirement for 24x7 DBA coverage 2.Complexity of database 3.Type of applications using the database 4.Database type (OLTP, DW etc.) 5.Number of tiers (two tier, three tier etc.) 6.Amount of input required into development of apps (tuning support and so on) And lots more as well. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Hamilton Sent: Tuesday, March 11, 2003 6:59 AM To: Multiple recipients of list 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: Pete Sharman 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). __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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).
RE: POLL: Database to DBA ratio
I currently have 5 development databases and 1 beta production database that I administer, so that's 6:1, but I'm also the Sys Admin for these servers as well. These are also very small databases. robin -Original Message- Sent: Tuesday, March 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We have 10 development databases that I support directly plus 5 implementation/testing databases that I support as second level and one production snapshot datamart. 16:1 However, there are also DBAs who support each project. That would make the ratio closer to 4:1 or 3:1. Chuck Hamilton chuckh To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @softhome.net cc: Sent by: rootSubject: POLL: Database to DBA ratio 03/11/2003 09:59 AM 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: Thomas Day 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: Robin Ilardi 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).
RE: POLL: Database to DBA ratio
28 Oracle (dev, test, qa prod) 3 SQL Server (arent I lucky? gag) 31:1 Todd Carlson -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene Sais Sent: Tuesday, March 11, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio 27 databases to 1 dba, mixed dev, test, and prod. [EMAIL PROTECTED] 03/11/03 11:29AM 3:1 Production, Development, my personal test DB : Me Craig Healey -Original Message- href="" PROTECTED]mailto:[EMAIL PROTECTED] Sent: 11 March 2003 14:59 To: Multiple recipients of list ORACLE-L 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. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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).
RE: POLL: Database to DBA ratio
Last place I was at was 35:1 but we had top notch guys and and organized environment..The kinds of databases you have.. what kinds of work being done on them etc. the high availability and service level agreement and change control requirments. Now we have mega-sensitive instances.. needing Now we have 3:1 Many of them have 3-way upgrades each year and we only have 8 months to do it in.. Saying all that is to say...its not apples to apples.. What we do- is, we map all the ongoing projects and resource out the dba's and when new projects come...we have a tool to communicate the resource requirements to management... something they understand when you say You want that project.. we need more resources... or what other project do you want to cancel. If you don't use a tool like this its easy to have managment pushing you into making all kinds of bad decisions and become heavily understaffed. Brian -Original Message- Sent: Tuesday, March 11, 2003 12:14 PM To: Multiple recipients of list ORACLE-L 6:2 six DBAs to one development + one testing VLDB. Good luck. -Original Message- Sent: Tuesday, March 11, 2003 11:29 AM To: Multiple recipients of list ORACLE-L 3:1 Production, Development, my personal test DB : Me Craig Healey -Original Message- From: Chuck Hamilton [mailto:[EMAIL PROTECTED] Sent: 11 March 2003 14:59 To: Multiple recipients of list ORACLE-L Subject: POLL: Database to DBA ratio 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. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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: Dong, Ping - Raleigh, NC 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).
RE: POLL: Database to DBA ratio
On the Oracle side there's 2 of us (myself and one other) supporting 20 databases, so that makes us 10:1. However, in addition to this there is also the IBM mainframe/Software AG Adabas side where it is my privilege to support the 5 legacy database environments by myself. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James Damiano 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).
RE: POLL: Database to DBA ratio
We currently have twenty-one databases, thirteen production and eight which are either test or development. Of the thirteen production databases five need to be up on a 24 X 7 basis; physics experiments and or accelerator monitoring depend on them. Nine of the production databases are Oracle back ends for third-party products including Peoplesoft and Remedy. All the above databases all administered by one DBA. We do have Peoplesoft Administrators, Remedy Administrators, System Administrators to take some of the load off, but I am responsible for the installation, upgrade, maintenance, tuning, and backup of all databases and Oracle software. This includes Internet Developer Suite and Internet Application Server, although as to the latter, I'm in the process of unloading it. This all works quite well most of the time. A problem can arise when I must devote my attention to fixing a pressing problem. In which case the reading of some reports on the non-24x7 databases may be postponed and the database then pages me about trouble which I could of fixed proactively had I read the reports. Larry E. talks of having a single database with third party certifications to consider and with multiple applications requiring 24 X 7 service this is impossible. We do of course have to negotiate down times for even the 24 X 7 applications, but their operational schedules make it impossible to have them all down at once. I do get vacations. A cell phone and a wide-area pager is a necessity, and I don't necessarily have to be at work from eight to five. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 11, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Chuck, At this location we have a total of 5 databases and 1 DBA. Time off without an electronic teather is a thing of the past. My last location was 4 production databases with 1 DBA and a backup DBA from the development arena of 2 development databases and 1 DBA. Ron [EMAIL PROTECTED] 03/11/03 09:59AM 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: Ron Rogers 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: MacGregor, Ian A. 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).
Re: POLL: Database to DBA ratio
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 AMDatabase 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).
RE: POLL: Database to DBA ratio
A simple num of databases to DBA ratio is quite meaningless. You need to take into consideration of at least the following: o Size of the database, transaction volume. What kind of up time your database needs to provide. o Complexity of the database and application which run on top of it. Number of objects, tables, stored procedures. Is there replication, partitioning, object types, RAC/OPS, etc involved? o Does the DBA also do some SA work, or development work or design etc. o How frequent is your development cycle. I am sure others will have lots of things to attribute. But you can't just say I have NNN number of databases and therefore need NN number of DBAs. Richard Ji -Original Message- Sent: Tuesday, March 11, 2003 6:59 AM To: Multiple recipients of list 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: Richard Ji 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).
Re: POLL: Database to DBA ratio
Chuck, I support 17 development, 2 production oracle databases, 3 DB2/MVS databases and 1 SQL Server. A coworker supports only 1 application and that is in UAT/Dev environment but it is a highly active application in the multi-Terabyte range (UDB). We have external prod. support for some of our apps (IBM). I think how many a DBA can support will depend upon a number of things such as (by no means a complete list): - Production Support and/or App. Dev support - Frequency of change to an application. Some stay in a constant state of change. - Complexity of system (ERP, n-tier, custom, vendor) - Procedures/processes/technology to allow easier support of multiple systems. David From: Chuck Hamilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: POLL: Database to DBA ratio Date: Tue, 11 Mar 2003 06:59:21 -0800 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). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis 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).
RE: POLL: Database to DBA ratio
139 remote production servers/instances (30 are large to VLDB, the rest small), 5 development instances, 1 9iAS test instance, 3 dba's. Mostly reporting with batch ETL jobs run nightly. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Robin Ilardi [SMTP:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 12:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: POLL: Database to DBA ratio I currently have 5 development databases and 1 beta production database that I administer, so that's 6:1, but I'm also the Sys Admin for these servers as well. These are also very small databases. robin -Original Message- Sent: Tuesday, March 11, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We have 10 development databases that I support directly plus 5 implementation/testing databases that I support as second level and one production snapshot datamart. 16:1 However, there are also DBAs who support each project. That would make the ratio closer to 4:1 or 3:1. Chuck Hamilton chuckh To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @softhome.net cc: Sent by: rootSubject: POLL: Database to DBA ratio 03/11/2003 09:59 AM 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: Thomas Day 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: Robin Ilardi 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).
Re: POLL: Database to DBA ratio
31:1 will be 40:1 by the end of the year. I have a second guy in training as the second DBA. 3:1 oracle app servers 23 24X7 medical databases of one type or annother 8 Dev/Test databases 1 production app server 2 dev/test app servers ...JIM... [EMAIL PROTECTED] 3/11/03 8:59:20 AM 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: James Howerton 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).
Re: POLL: Database to DBA ratio
Chuck, That's not really a good measure. It really depends on a number of things. * number of users * number of apps * size of db's * quality of apps ( some require more work than others ) * amount of new development * lots more I can't think of at the moment... Best thing to do is document the advantages of additional staff. If it can save the company $$, they will go for it. The savings will come in from less downtime, apps get put in production sooner, ... Jared Chuck Hamilton [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/11/2003 06:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:POLL: Database to DBA ratio 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).
RE: POLL: Database to DBA ratio
We're 5 DBA including the team leader. We have 130 Oracle DB + 40 Sql Server 2000 + 6 DB2 mainframe. And we're doing development (data modeling ) and supposed to be involved in architecture now. Also, you should take in account if it's production or development work. Are you involved in data modeling ? on the unix side ? ... I hope you send all answers in a nice excel spreadsheet ! Stephane -Original Message- Hamilton Sent: Tuesday, March 11, 2003 9:59 AM To: Multiple recipients of list 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: Stephane Paquette 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).
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 AMDatabase 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).