bcc:
Subject:
RE: POLL:
Database to DBA ratio
Title: RE: POLL: Database to DBA ratio
In our
environment, each DBA supports a certain number of databases that are
his/her 'primary' databases (all the way from Test/Dev/Accept/Production). The
same person is 'secondary' or 'tertiary' for others. We follow a
Title: RE: POLL: Database to DBA ratio
In my
shops we use a similar matrix to this for management and assignment. In
short, on-call rotates weekly and the "on-call" responsibility covers non
business hours (eg: 7pm - 8am). The remainder of the time the environment
DB
Title: RE: POLL: Database to DBA ratio
With such a large # of databases to support, how do
you divide up the work? Does everyone administer all of the databases, or are
databases assigned to a DBA? How do you handle on-call?
- Original Message -
From:
Adams,
Matthew (GECP
PROTECTED] Sent: Wednesday, March 12, 2003
12:51To: Multiple recipients of list ORACLE-LSubject:
RE: POLL: Database to DBA ratio
We have 4 production Oracle databases and 3 DBA's.
Of course, we have additional duties as well. I spend many
afternoons out at the airpo
ime/efficiency
Rate of change of db
Number of managers interested in using you as a resource
Number of servers
Uptime requirements
Rate of development
Niall
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> Chuck Hamilton
> Sent: 11 Ma
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
--Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> Chuck Hamilton
> Sent: 11 March 2003 21:29
> To: Multiple recipients of list ORACLE-L
> Subject: Re: POLL: Database to DBA ratio
>
>
> You are the first reply out of at least 20 (public and
&g
Well, I'll add my $00.02 worth.
I have about 15 databases, more or less. It varies depending on
what's going on. Right now it's more. :)
They are on NT, Win2k, Solaris and Linux.
Sizes range from a few gig to 450 gig.
In addition, I own IT change control ( Oh joy ), and a
few other goodies
: Multiple recipients of list ORACLE-LSubject:
RE: POLL: Database to DBA ratio
We have 4 production Oracle databases and 3 DBA's.
Of course, we have additional duties as well. I spend many
afternoons out at the airport as a baggage handler for Horizon
Airlines.
--Walt Weaver Bo
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
Title: RE: POLL: Database to DBA ratio
We have 4 production Oracle databases and 3 DBA's.
Of course, we have additional duties as well. I spend many afternoons out at the airport as a baggage handler for Horizon Airlines.
--Walt Weaver
Bozeman, Montana
> -Original
Title: RE: POLL: Database to DBA ratio
350 Oracle Databases spread across US and Europe.
14 full time, 4 part time.
75% of applications are designed and built in-house.
-Original Message-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 12, 2003 1:59 PM
To
We have over 400 databases, 90%+ are Oracle under various versions, platforms.
Today have 19 DBAs. Two weeks from now there will be 17.
Rightsizing to continue in the 2nd Quarter
- Kirti
-Original Message-
Sent: Wednesday, March 12, 2003 12:09 PM
To: Multiple recipients of list
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
Got the overall the nitty on our ratio
15 Dbas in all
1 DBA : 200 Sqlserver databases :) ( Management loves that ratio)
10 DBA: 100 Unix Oracle Databases, 10 NT Oracle DB :)
4 DBA : 40 DB2 and 43 Teradata databases
See that SQLSERVER Database ratio... show that to your boss.. make him sing
Dixi
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
We're 5 DBA including the team leader.
We have 130 Oracle DB + 40 Sql Server 2000 + 6 DB2 mainframe.
And we're doing development (data modeling ) and supposed to be involved in
architecture now.
Also, you should take in account if it's production or development work.
Are you involved in data mode
Chuck,
That's not really a good measure. It really depends on
a number of things.
* number of users
* number of apps
* size of db's
* quality of apps ( some require more work than others )
* amount of new development
* lots more I can't think of at the moment...
Best thing to do is document th
31:1 will be 40:1 by the end of the year. I have a second guy in training as the
second DBA.
3:1 oracle app servers
23 24X7 medical databases of one type or annother
8 Dev/Test databases
1 production app server
2 dev/test app servers
...JIM...
>>> [EMAIL PROTECTED] 3/11/03 8:59:20 AM >>>
I'm
SMTP:[EMAIL PROTECTED]
> Sent: Tuesday, March 11, 2003 12:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: POLL: Database to DBA ratio
>
> I currently have 5 development databases and 1 "beta" production database
> that I administer, so that'
Chuck,
I support 17 development, 2 production oracle databases, 3 DB2/MVS databases
and 1 SQL Server. A coworker supports only 1 application and that is in
UAT/Dev environment but it is a highly active application in the
multi-Terabyte range (UDB). We have external prod. support for some of our
A simple num of databases to DBA ratio is quite meaningless.
You need to take into consideration of at least the following:
o Size of the database, transaction volume. What kind of up time your
database
needs to provide.
o Complexity of the database and application which run on top of it.
Consider yourself lucky. We've got a 71:1 ratio here.
"Chuck Hamilton"
We currently have twenty-one databases, thirteen production and eight which are
either test or development. Of the thirteen production databases five need to be up
on a 24 X 7 basis; physics experiments and or accelerator monitoring depend on them.
Nine of the production databases are Oracl
On the Oracle side there's 2 of us (myself and one other) supporting 20
databases, so that makes us 10:1.
However, in addition to this there is also the IBM mainframe/Software AG
Adabas side where it is my privilege to support the 5 legacy database
environments by myself.
Jim Damiano
--
Please
Last place I was at was 35:1 but we had top notch guys and
and organized environment..The kinds of databases you have..
what kinds of work being done on them etc.
the high availability and service level agreement and change
control requirments.
Now we have mega-sensitive instances.. needing Now w
: RE: POLL: Database to DBA
ratio
27 databases to 1 dba, mixed dev, test, and prod.
>>> [EMAIL PROTECTED] 03/11/03 11:29AM >>>
3:1
Production, Development, my personal test DB : Me
Craig Healey
> -Original Message-
> href="" PROTECTED]">mailto
I currently have 5 development databases and 1 "beta" production database
that I administer, so that's 6:1, but I'm also the Sys Admin for these
servers as well. These are also very small databases.
robin
-Original Message-
Sent: Tuesday, March 11, 2003 11:44 AM
To: Multiple recipients
volume of database structural changes (new tables, changes to existing
ones) is another to add to that list
--- Pete Sharman <[EMAIL PROTECTED]> wrote:
> 33 DBA's to one database? That's pretty danged good! :)
>
> Seriously, this is a question that comes up every so often within
> Oracle
> as
6:2
six DBAs to one development + one testing VLDB. Good luck.
-Original Message-
Sent: Tuesday, March 11, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L
3:1
Production, Development, my personal test DB : Me
Craig Healey
> -Original Message-
> From: Chuck Hamilton [mai
> >>> [EMAIL PROTECTED] 03/11/03 09:59AM >>>
> 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
Chuck
I think this is a slippery argument. It may appeal to managers but can
lead to bad decisions long-term. Does anyone remember years ago when
managers would measure COBOL programmers LOC (lines of code)? Just measure
how many lines of code each programmer writes each day and vola! you know
w
27 databases
to 1 dba, mixed dev, test, and prod.>>> [EMAIL PROTECTED]
03/11/03 11:29AM >>>3:1 Production, Development, my personal
test DB : MeCraig Healey> -Original Message->
href="">mailto:[EMAIL PROTECTED]> Sent:
11 March 2003 14:59> To: Multiple recipients of list ORACLE-L>
bu
We have 10 development databases that I support directly plus 5
implementation/testing databases that I support as second level and one
production snapshot datamart.
16:1
However, there are also DBAs who support each project. That would make the
ratio closer to 4:1 or 3:1.
33 DBA's to one database? That's pretty danged good! :)
Seriously, this is a question that comes up every so often within Oracle
as well, as clients ask Oracle employees what should be expected.
There's no simple answer to it. As you might expect, the answer is "it
depends". :)
Depends on (a
3:1
Production, Development, my personal test DB : Me
Craig Healey
> -Original Message-
> From: Chuck Hamilton [mailto:[EMAIL PROTECTED]
> Sent: 11 March 2003 14:59
> To: Multiple recipients of list ORACLE-L
> Subject: POLL: Database to DBA ratio
>
>
> I'm trying to build a case for ma
Chuck,
At this location we have a total of 5 databases and 1 DBA. Time off
without an electronic teather is a thing of the past. My last location
was 4 production databases with 1 DBA and a backup DBA from the
development arena of 2 development databases and 1 DBA.
Ron
>>> [EMAIL PROTECTED] 03/1
38 matches
Mail list logo