Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

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

Tony Jambu

2006-06-13

Replies:


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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.