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