Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








Oracle vs. SQL Server

Oracle Tips by Burleson Consulting
November 9 2015

For those of us plagued by marketing hype about why you should run your databases on SQL Server & Windows vs. Oracle on Linux:

Here are related notes comparing SQL Server to Oracle: has recently published at detailed comparison of the relative merits of Oracle Vs. SQL Server:

The evaluator, Eli Leiba, works at the Israel Electric Company as a senior application DBA in Oracle and Microsoft SQL Server, and has certifications in Oracle and SQL Server database administration and implementation. Additionally, Mr. Leiba teaches SQL Server DBA and development courses at the Microsoft CTEC.

Leiba compares SQL Server to Oracle along the following lines:

  • Platform dependency  (Guess who wins here?)

  • Locking and concurrency

  • Performance & tuning

  • Object Types

  • Procedural languages (PL/SQL vs. T-SQL)

  • Clustering Technology

  • Reliability

For example, here are Mr. Leiba?s comparison of Oracle vs. SQL Server performance features:

  • In SQL Server, the DBA has no "real" control over sorting and cache memory allocation. The memory allocation is decided only globally in the server properties memory folder, and that applies for ALL memory and not CACHING, SORTING, etc.

  • In SQL Server, all pages (blocks) are always 8k and all extents are always 8 pages (64k). This means you have no way to specify larger extents to ensure contiguous space for large objects.

  • In SQL Server, no range partitioning of large tables and indexes. In Oracle, a large 100 GB table can be seamlessly partitioned at the database level into range partitions. For example, an invoice table can be partitioned into monthly partitions. Such partitioned tables and partitioned indexes give performance and maintenance benefits and are transparent to the application.

  • There is no partitioning in SQL Server.

  • There are no bitmap indexes in SQL Server.

  • There are no reverse key indexes in SQL Server.

  • There are no function-based indexes in SQL Server.

  • There is no star query optimization in SQL Server.

Tony Jambu Notes:  Oracle 10g vs. SQL Server

Given the release of 10gR2, Oracle seems to be moving ahead of its competitors. But where are its competitors in terms of their technical features? The one database competitor we hear a lot about is Microsoft's SQL Server.

With its imminent release of MS-SQL Server 2005 also known as Yukon, it pays to be aware of it strengths and weaknesses as compared to Oracle's 10g.

The hard work of comparing the two databases, Oracle 10g and MS-SQL Server 2005 (beta) has been done by David Gornshtein and Boris Tamarkin of WisdomForce Technologies, Inc

David and Boris have produced a comprehensive technical whitepaper comparing their features, strengths and weaknesses. This has to be the most detailed and unbiased report I have come across. They definitely have an in-depth knowledge of both Oracle 10g and MS-SQL Server 2005 (beta). The report is being quoted on all the major trade websites. Just do a search on "Oracle 10g and MS-SQL Server 2005" and you will find this report turning up every where.

Did you know that MS-SQL Server 2005 now has:

- New locking mechanisms. Writers don't block readers (yawn).
- With Snapshot Isolation (SI) there is data consistency on transaction begin.
- With "Read committed snapshot" isolation level which provides for read consistency.
- New online data and index reorganization
- Physical table and indexing portioning
- The use of Btree for indexes
- Specialized index on a computed column (ala Function based Index)
- Indexed View (ala Materialized Views)
- Replication via Peer-to-Peer Transaction replication and Database mirroring
- More online backup and recovery options

Oracle Training from Don Burleson 

The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!

Oracle training



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.