RE: How many databases do you support?

From: Vincent Ruger <Vincent.Ruger_at_nos.nl>
Date: Thu, 14 Sep 2000 10:22:07 +0200
Message-Id: <10619.116948@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C01E24.E3581852
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

We have 9 prod db, 5 test db and 4 db's that are used for = user-acceptance.
(and one db on NT, hardly used and one on foxpro) on 8 aix boxes (seven = of
then are on a sp2, switch not used)
The versions vary from 7.3.4 / 8.0.5 / 8.1.6.

2 dba's and =BD unix sa...

Vincent Ruger

-----Oorspronkelijk bericht-----
Van: root_at_fatcity.com [mailto:root_at_fatcity.com]Namens Rachel Carmichael Verzonden: woensdag 13 september 2000 23:41 Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: How many databases do you support?

current job: 7 production, 2 development databases

1 full-time DBA (me) and one consultant DBA who works off-site 3 days a = week

and the number is going to grow. But I am also getting another DBA=20 mid-October.

>From: "Ron Rogers" <RROGERS_at_galottery.org>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: How many databases do you support?
>Date: Wed, 13 Sep 2000 10:56:19 -0800
>
>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).

________________________________________________________________________=

_
Get Your Private, Free E-mail from MSN Hotmail at = http://www.hotmail.com.

Share information about yourself, create your own public profile at=20 http://profiles.msn.com.

--=20
Author: Rachel Carmichael
INET: carmichr_at_hotmail.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).

------_=_NextPart_001_01C01E24.E3581852
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: How many databases do you support?</TITLE>
</HEAD>
<BODY>

Hi,

We have 9 prod db, 5 test db and 4 db's that are used = for user-acceptance. (and one db on NT, hardly used and one on foxpro) = on 8 aix boxes (seven of then are on a sp2, switch not used)

The versions vary from 7.3.4 / 8.0.5 / 8.1.6.

2 dba's and =BD unix sa...

<P><FONT SIZE=3D2>Vincent Ruger</FONT>
</P>
<BR>

-----Oorspronkelijk bericht----- Van: root_at_fatcity.com [<A = HREF=3D"mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</A>]Namens = Rachel Carmichael

<BR><FONT SIZE=3D2>Verzonden: woensdag 13 september 2000 23:41</FONT>
<BR><FONT SIZE=3D2>Aan: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Onderwerp: Re: How many databases do you =

support?

current job:  7 production, 2 development = databases

1 full-time DBA (me) and one consultant DBA who works = off-site 3 days a week

and the number is going to grow. But I am also = getting another DBA 
 mid-October.

>From: "Ron Rogers" = <RROGERS_at_galottery.org>
 >Reply-To: ORACLE-L_at_fatcity.com >To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com>
 >Subject: Re: How many databases do you = support?

<BR><FONT SIZE=3D2>&gt;Date: Wed, 13 Sep 2000 10:56:19 -0800</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Current job 2 machines, 3 databases. 2 live , 1 =

development.
 >Previous job 4 machines, 4 databases. 2 live, 1 = hot backup, 1 development.

<BR><FONT SIZE=3D2>&gt;1 DBA/SYSADMIN</FONT>
<BR><FONT SIZE=3D2>&gt;ROR</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt; &gt;&gt;&gt; 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,

<BR><FONT SIZE=3D2>&gt;24/7, etc.</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;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

<BR><FONT SIZE=3D2>&gt;of DBAs supporting them?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;How many databases do you support on =

average?

<BR><FONT SIZE=3D2>&gt;What is the size of your team?</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Trying to get ideas for the head count of our =

DBA team
 >here and wondering what the industry standard = is.

<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Thanks</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Cherie</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;--</FONT>
<BR><FONT SIZE=3D2>&gt;Author:</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp; 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
 <FONT =

SIZE=3D2>&gt;-----------------------------------------------------------=

---------
 >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).

<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;--</FONT>
<BR><FONT SIZE=3D2>&gt;Author: Ron Rogers</FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp;&nbsp; INET: RROGERS_at_galottery.org</FONT>
<BR><FONT SIZE=3D2>&gt;</FONT>
<BR><FONT SIZE=3D2>&gt;Fat City Network Services&nbsp;&nbsp;&nbsp; -- =

(858) 538-5051  FAX: (858) 538-5051 >San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>&gt;-----------------------------------------------------------=

<FONT =

SIZE=3D2>_______________________________________________________________=

__________
 Get Your Private, Free E-mail from MSN Hotmail at <A = HREF=3D"http://www.hotmail.com" =
TARGET=3D"_blank">http://www.hotmail.com</A>.

Share information about yourself, create your own = public profile at 
 <A HREF=3D"http://profiles.msn.com" = TARGET=3D"_blank">http://profiles.msn.com</A>.

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Rachel Carmichael</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: carmichr_at_hotmail.com</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----
 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 = Received on Thu Sep 14 2000 - 03:22:07 CDT