| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: MS SQL hasn't given up!
Hi
I saw this list posted on an Oracle Newsgroup a while back :-)
Oracle has multiversioning. SQL Server has no equivalent
In Oracle reads don't block writes and writes don't block reads
In Oracle there are unlimited row level locks
In Oracle there is no such thing as lock escallation or page level
locking
In Oracle there is no need to use temp tables to accumulate intermediate
level results
In Oracle phyiscal transactions can be as large as logical transactions.
No need to fragment them
Oracle runs on platforms other than Windows
Oracle has many trigger types not available in SQL Server
Oracle lines the pockets of Larry Ellison rather than Bill Gates. Which
means that someone is having fun with your money rather than just
hoarding it.
Also look at the link below for a longish (400+ lines) and very detailed
technical comparison.
http://groups.google.com/groups?q=faulkner+oracle+sqlserver&hl=en&lr=lang_en
&ie=UTF-8&oe=UTF-8&newwindow=1&selm=FssV9.25204%24jM5.66998%40newsfeeds.bigp
ond.com&rnum=4
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Dale_at_DataBee.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Feb 28 2003 - 12:24:29 CST
 |
 |