Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: POLL: Database to DBA ratio

RE: POLL: Database to DBA ratio

From: <DEEDSD_at_Nationwide.com>
Date: Thu, 13 Mar 2003 06:44:04 -0800
Message-ID: <F001.00568F42.20030313064404@fatcity.com>

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"                                                                         
                          <BSpears_at_Limitedbrands.  T                                                              
                          com>                     To:   Multiple recipients of list ORACLE-L                     
                                                   <ORACLE-L_at_fatcity.com>                                         
                          Sent by:                 cc:                                                            
                          root_at_fatcity.com                                                                        
                                                   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"

                          <chuckh_at_softhome.net>    T

                                                   To:   Multiple
recipients
of list ORACLE-L
                          Sent by:                 <ORACLE-L_at_fatcity.com>

                          root_at_fatcity.com         cc:



                                                   bcc:

                                                   Subject:
Re: POLL:
                          03/11/03 04:29 PM        Database 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.

>
> Consider yourself lucky. We've got a 71:1 ratio here.
>
>
>
> "Chuck Hamilton"
> <chuckh_at_softhome.net> T
> To: Multiple
recipients of list ORACLE-L
> Sent by: <ORACLE-L_at_fatcity.com>
> root_at_fatcity.com cc:
>
> bcc:
> Subject:
POLL:
> 03/11/03 09:59 AM Database to DBA ratio

> Please respond to
> ORACLE-L
>
>
>
>
>
>
> I'm trying to build a case for management that we need additional DBAs so
> I'd like to take a quick poll if I may. What is the ratio of Oracle
> databases to DBAs in your shop? This includes development and production
> databases. At our shop it's 33:1.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chuck Hamilton
> INET: 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).
>
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: DEEDSD_at_Nationwide.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).







--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: DEEDSD_at_Nationwide.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:
  INET: DEEDSD_at_Nationwide.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: Spears, Brian
  INET: BSpears_at_Limitedbrands.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: 
  INET: DEEDSD_at_Nationwide.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).
Received on Thu Mar 13 2003 - 08:44:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US