Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: <F.Castillo_at_hzd.hessen.de>
Date: Tue, 13 Jun 2006 13:22:58 +0200
Message-ID: <325B075345858C44B357B09A7AF4A4BD027BA8F6@srvhzdexc095.hzd.hessen.de>


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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von Tony Jambu Gesendet: Dienstag, 13. Juni 2006 13:08
An: Oracle-L_at_freelists.org
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 Received on Tue Jun 13 2006 - 06:22:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US