Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)

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

From: <>
Date: Tue, 13 Jun 2006 08:00:34 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF6812E7@EXCNYSM0A1AJ.nysemail.nyenet>

I also think that the sample is too small.

"The distributions were fairly similar for the two database systems, with one exception that slightly over half (53%) of the organizations had ten or less production Oracle Database servers".

This skews the results toward Sql Server. If they had sampled more Oracle shops, they would have found *a lot* more databases per shop.

I have over 60 Oracle databases here.

-----Original Message-----

From: [] On Behalf Of Laimutis Nedzinskas Sent: Tuesday, June 13, 2006 7:49 AM
Subject: RE: DBAs:Databases 1:10 (Oracle) 1:31 (SQL Server)

well, it seems that the term "database" in this report is more or less adequate.

Calculating by user numbers is quite a new idea in measuring database load but let it be so.

There is another fact that can be drawn from the report:

Average number of users per company is:

35,096(MS) vs 62,292(Oracle)

Which probably means 2 times bigger company, more users, higher cost of failure.

In that light "Annual TCA per database user $13.09(MS) vs $18.15(Oracle)" does not seems so bad.

-----Original Message-----

From: [] On Behalf Of Tony Jambu Sent: 13. júní 2006 11:08
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

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.




-- Received on Tue Jun 13 2006 - 07:00:34 CDT

Original text of this message