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

Home -> Community -> Usenet -> c.d.o.server -> Re: Comparisons of TCA between Oracle and SQL Server

Re: Comparisons of TCA between Oracle and SQL Server

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 24 Sep 2006 13:47:09 -0700
Message-ID: <1159130829.914327@bubbleator.drizzle.com>


Niall Litchfield wrote:

> Walt wrote:

>>
>> The most interesting graph:
>>
>> Study participants reported that on average a database
>> administrator could manage more than 30 Microsoft SQL Server
>> 2005 databases, while Oracle 10g implementations required one
>> DBA per 10 databases. On average, the annual cost for
>> administration is $2,847 per year per database for Microsoft
>> SQL Server 2005 and $10,206 per year per database for Oracle
>> 10g. That's a savings of more than 350% in annual costs per
>> database for the Microsoft platform.
>>
>> One wonders if the authors understand that the term "database" as used
>> by SQL Server is equivalent to the term "schema" in Oracle. For
>> instance, I only admin one Oracle production database (mostly I'm a
>> developer), but it has over 30 schemas.
> 
> Given that the actual survey talks about database servers rather than 
> databases per se, I think that its entirely possible that they know the 
> difference.

I received a reply from the author. He seems to know absolutely nothing about Oracle beyond the fact that his company has both SQL Server and Oracle. He was unable to address the fact that in Oracle database <> instance <> schema or to understand the implications of his question.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Sun Sep 24 2006 - 15:47:09 CDT

Original text of this message

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