Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: POLL: Database to DBA ratio
RE: POLL: Database to DBA ratioWith 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?
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:kirti.deshpande_at_verizon.com]
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....
-----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: kirti.deshpande_at_verizon.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: chuckh_at_softhome.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 12 2003 - 18:03:51 CST