RE: How many databases do you support?

7 production databases, one on Sun, 5 on hp10.20 and one on hp11 64-bit. 1 training database I never touch unless they bring the box down, 1 test database, and 1 development database. 1 dba plus 2 backups for those days I feel like getting out of pager range. Currently 3 SA's but it was one very over worked one for a while. The databases range from 7.3.3 to 8.1.5. I also support Unicenter on top of that with an SQL Server database so I am rarely bored.

-----Original Message-----
From: Anne Yu [mailto:AYu_at_sos.state.tx.us] Sent: Thursday, September 14, 2000 12:41 PM To: Multiple recipients of list ORACLE-L Subject: 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-----
Sent: Wednesday, September 13, 2000 4:01 PM To: Multiple recipients of list ORACLE-L

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-----
<mailto:RROGERS_at_galottery.org> ]
Sent: Wednesday, September 13, 2000 2:56 PM To: Multiple recipients of list ORACLE-L

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 
also send the HELP command for other information (like subscribing). 

-- 
Author: Anne Yu
  INET: AYu_at_sos.state.tx.us

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