Hi,
How do they compare MS to Oracle
In Oracle term a database would be what a MS/Sybase call a "SQL Server". They have lots of databases - a thing that compares to a combination of schema/tablespace, if I'm not completely wrong.
So what does Alinea _exactly_ mean by the term 'database'?
Felix
PS: I've actually not the time to read the hole n-page paper :-(
-----Urspr?ngliche Nachricht-----
Von: oracle-l-bounce@(protected)
Gesendet: Dienstag, 13. Juni 2006 13:08
An: Oracle-L@(protected)
Betreff: 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
--
http://www.freelists.org/webpage/oracle-l
