RE: How many databases do you support?

3 production databases (24x7) over 200 GB , 20 dvlp/test/prod databases under 1GB, 6 servers, 1 DBA, 1 SA as backup. The DBA is bored, spent most of his time reading tech books.

-----Original Message-----
From: Bill Conner [mailto:bconner_at_verio.net] Sent: Wednesday, September 13, 2000 4:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: How many databases do you support?

63 + oracle db's on 55 servers, 5 sybase, and one mssql, With 1 mssql, 1 sybase and 3 oracle dba's.
i doubt that this is normal but have never seen this asked before, interesting question.

At 12:20 PM 9/13/00 -0800, Koivu, Lisa wrote:

Hi Cherie,

Here we have 3 dedicated db hosts, 4 databases. 1 DBA, 1 SA, plus one person who can back both of us up.

I hope this helps you. I know your numbers are a complete nightmare.

Lisa

-----Original Message-----
From: Ron Rogers [ mailto:RROGERS_at_galottery.org <mailto:RROGERS_at_galottery.org> ]
Sent: Wednesday, September 13, 2000 2:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: How many databases do you support?

Current job 2 machines, 3 databases. 2 live , 1 development. Previous job 4 machines, 4 databases. 2 live, 1 hot backup, 1 development. 1 DBA/SYSADMIN
ROR
>>> Cherie_Machler_at_gelco.com 09/13/00 02:36PM >>>
Is there any sort of rule-of-thumb for how many database that a DBA should be expected to support? I realize that the answer would vary based on size of databases, stability, production vs. development, mission critical, 24/7, etc.

But in general, how many databases would you think a DBA should be supporting if you divide the total number of databases in an organization by the number of DBAs supporting them?

How many databases do you support on average? What is the size of your team?

Trying to get ideas for the head count of our DBA team here and wondering what the industry standard is.

Thanks

Cherie

-- 
Author: 
  INET: Cherie_Machler_at_gelco.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California        -- Public Internet access / Mailing Lists 
-------------------------------------------------------------------- 
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). 

-- 
Author: Ron Rogers 
  INET: RROGERS_at_galottery.org 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California        -- Public Internet access / Mailing Lists 
-------------------------------------------------------------------- 
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