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: How many databases do you support?

RE: How many databases do you support?

From: Bill Conner <bconner_at_verio.net>
Date: Wed, 13 Sep 2000 13:57:34 -0600
Message-Id: <10618.116893@fatcity.com>

--=====================_78776257==_.ALT

Content-Type: text/plain; charset="us-ascii"; format=flowed

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

--=====================_78776257==_.ALT

Content-Type: text/html; charset="us-ascii"

<html>
63 + oracle db's on 55 servers,&nbsp; 5 sybase, and one mssql,&nbsp; With 1 mssql, 1 sybase and 3 oracle dba's. <br> i doubt that this is normal but have never seen this asked before,&nbsp; interesting question.<br>
<br>
At 12:20 PM 9/13/00 -0800, Koivu, Lisa wrote:<br>

<br>
<blockquote type=cite class=cite cite><font size=2>Hi Cherie, <br>
</font><br>
<font size=2>Here we have 3 dedicated db hosts, 4 databases.&nbsp; 1 DBA,
1 SA, plus one person who can back both of us up. <br> </font><br>
<font size=2>I hope this helps you.&nbsp; I know your numbers are a complete nightmare. <br>
</font><br>
<font size=2>Lisa</font> <br>
<br>
<font size=2>-----Original Message-----</font> <br>
<font size=2>From: Ron Rogers

[<a href="mailto:RROGERS_at_galottery.org">mailto:RROGERS_at_galottery.org</a>]</font>
<br>
<font size=2>Sent: Wednesday, September 13, 2000 2:56 PM</font> <br>
<font size=2>To: Multiple recipients of list ORACLE-L</font> <br>
<font size=2>Subject: Re: How many databases do you support?</font> 
<br>
<br>
<font size=2>Current job 2 machines, 3 databases. 2 live , 1 development.</font> <br>
<font size=2>Previous job 4 machines, 4 databases. 2 live, 1 hot backup, 1 development.</font> <br>
<font size=2>1 DBA/SYSADMIN</font> <br>
<font size=2>ROR</font> <br>
<br>
<font size=2>&gt;&gt;&gt; Cherie_Machler_at_gelco.com 09/13/00 02:36PM &gt;&gt;&gt;</font> <br>
<font size=2>Is there any sort of rule-of-thumb for how many database</font> <br>
<font size=2>that a DBA should be expected to support?&nbsp;&nbsp; I realize</font> <br>
<font size=2>that the answer would vary based on size of databases,</font> <br>
<font size=2>stability, production vs. development, mission critical,</font> <br>
<font size=2>24/7, etc.</font> <br>
<br>
<font size=2>But in general, how many databases would you think</font> <br>
<font size=2>a DBA should be supporting if you divide the total</font> <br>
<font size=2>number of databases in an organization by the number</font> <br>
<font size=2>of DBAs supporting them?</font> <br>
<br>
<font size=2>How many databases do you support on average?</font> <br>
<font size=2>What is the size of your team?</font> <br>
<br>
<font size=2>Trying to get ideas for the head count of our DBA team</font> <br>
<font size=2>here and wondering what the industry standard is.</font> <br>
<br>
<font size=2>Thanks</font> <br>
<br>
<font size=2>Cherie</font> <br>
<br>
<font size=2>-- </font><br>
<font size=2>Author: </font><br>
<font size=2>&nbsp; INET: Cherie_Machler_at_gelco.com <br>
</font><br>
<font size=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</font> <br>
<font size=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</font> <br>
<font size=2>--------------------------------------------------------------------</font> <br>
<font size=2>To REMOVE yourself from this mailing list, send an E-Mail message</font> <br>
<font size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</font> <br>
<font size=2>the message BODY, include a line containing: UNSUB ORACLE-L</font> <br>
<font size=2>(or the name of mailing list you want to be removed from).&nbsp; You may</font> <br>
<font size=2>also send the HELP command for other information (like subscribing).</font> <br>
<br>
<font size=2>-- </font><br>
<font size=2>Author: Ron Rogers</font> <br>
<font size=2>&nbsp; INET: RROGERS_at_galottery.org</font> <br>
<br>
<font size=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</font> <br>
<font size=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</font> <br>
<font size=2>--------------------------------------------------------------------</font> <br>
<font size=2>To REMOVE yourself from this mailing list, send an E-Mail message</font> <br>
<font size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</font> <br>
<font size=2>the message BODY, include a line containing: UNSUB ORACLE-L</font> <br>
<font size=2>(or the name of mailing list you want to be removed from).&nbsp; You may</font> <br>
Received on Wed Sep 13 2000 - 14:57:34 CDT

Original text of this message

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