| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: POLL: Database to DBA ratio
In our environment, each DBA supports a certain number of databases that 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 standardized setup (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 are changed routinely! All DBAs are on call all of the time. Every 2 hours the automated paging mechanism/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 database names.
This is working great for over 5 years now....
-----Original Message-----
Sent: Wednesday, March 12, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L
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?
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-----
Sent: Wednesday, March 12, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L
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 servicesReceived on Thu Mar 13 2003 - 07:58:56 CST
---------------------------------------------------------------------
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).
 |
 |