RE: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)

>I find it hard to believe that the average Oracle DBA can manage only 10 databases.

What is a database, in common terms of MS and Oracle?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tony Jambu Sent: 13. júní 2006 11:08
To: Oracle-L_at_freelists.org
Subject: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)

Hi all

Recently, I came across an 'interesting' paper on the comparative difference of the total cost of database administration between Oracle and SQL Server. It was conducted by Alinean.

Some interesting findings:

Measure                                         Microsoft   Oracle
---------------------------------------         ---------  ------
Average number of databases per company         107         87
Average number of users per database            328         716
Mission critical databases                      66.1%       63.8%
Transaction-based databases                     55.7%       60.3%
Decision-support databases                      44.3%       39.7%
*** Databases supported per DBA                 31.2        9.9 
Users supported per DBA                         6,784       5,567
Annual TCA per database                         $2,847      $10,206
Annual TCA per database user                    $13.09      $18.15

If you cant read the above, make sure you have it as fixed font or goto http://www.alinean.com/PDFs/Alinean-MicrosoftAndOracleTCAStudy.pdf

I find it hard to believe that the average Oracle DBA can manage only 10 databases.  From memory, a past survey on best practices indicated that an Oracle DBA manages on average about 30 Oracle databases.

I guess for my own interest and possibly all those interested too, we could work out what our ratio of DBAs:Databases. If you are so kind as to reply to the following questions.

Q1.  How many DBAs are in your company
Q2.  How many Production Databases (Oracle + others) do they manage
Q2.  How many Test/Dev Databases (Oracle + others) do they manage

If you do not wish to publish the figures directly to this list, just send me an email and I will collate it after a week.

tony

--
http://www.freelists.org/webpage/oracle-l


Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer
--
http://www.freelists.org/webpage/oracle-l