Tuesday, April 24, 2007

A bit of silliness

On AskTom, there's a huge thread that's been running for 5+ years called Comparison between Oracle and Others. As one might expect, the debates get a bit "religious" and some posters try to put down the Oracle database. That's fine, but a few sites are linked to that make ridiculous claims about Oracle, really only proving that the authors don't understand the database. Some claims are unsubstantiated, some make zero sense. For example, Oracle is too expensive and has a high TCO, or you "no real numeric data types". (???) I've seen similarly ridiculous trashings on Slashdot such as, this post that claims Oracle focuses only on "ruining successful companies"(because destroying customers is a good business model, you know) - http://slashdot.org/comments.pl?sid=208928&cid=17040380

Anyway, I decided to have a little fun and post my own list of Oracle gripes. Total joke, though some people didn't seem to get it. Perhaps my satire is too subtle. :) Here it is:

Major flaws in Oracle that I've found:

1) I tried installing Oracle on my Commodore 64 and it crashed. I reported the problem to support and they said I had to upgrade. Those jerks.
2) The alert log keeps getting bigger. This is a security flaw because eventually the disk will get full and Oracle will hang.
3) The "undo tablespace" is a worthless feature that just slows down the database. Support said I should try putting it on another disk. I'm really starting to hate those guys.
4) No support for null primary keys.
5) I need a table with 1001 columns and Oracle only supports 1000. Tom Kyte says there's something wrong with my design. What an insult.
6) I deleted all the data in the table and it still took up space.
7) Because TOAD exists, every GUI tool Oracle offers is horrible.
8) Everything you do is logged, whether you like it or not, wasting an average of 12.7499 GB/min according to www.microsoft.com/fairandbalanced/whyoracleisevil.php
9) Oracle charges you $300 per row returned. One time I accidentally cross joined instead of inner joined and I had to file for bankruptcy.
10) In SQL*Plus, you can't run Java commands unless you create a "Java Stored Procedure" and even then you're forced to call a static method. Static methods are so 80s. They went out with The Culture Club and velcro sneakers. Get with the times, Oracle.
11) I can't get dirty reads with Oracle. It should be a standard database feature for me to be able to read your incomplete transaction. If you're transferring $1000 from your savings to checking account, I should be able to see your savings down by $1000 before checking is increased by $1000. This way the check I'm trying to clear bounces even though you have the money. Oracle arrogantly breaks this standard. Stay away from this awful software.
12) Data types are all screwed up. Dates are stored as numbers and you can't specify precision or format, and you can't even cast a long raw to a rowid.
13) In fact, VARCHAR3 and 4 don't even work AT ALL.
14) I tried modifying Oracle data files in Windows Notepad and the database broke. Support told me you can't do that with Oracle...Obviously the software is inflexible in its methods of data access.
15) It's slow even when I index every column.
16) Try returning a hash table of 2D arrays of cursors pointing to user passwords in Oracle. Can't do it.
17) No one would ever use Oracle for a serious business. Sure Blizzard uses Oracle for its 8.5 million user MMORPG, but that's the exception, not the rule. They should have used MySQL and saved money.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1886476148373#236100400346362272

1 comment:

Scott Horowitz said...

Having had worked with Mark for clsoe to 2 years, he's a pretty good database guy. He taught me a lot about Oracle, and now I get to hear all his postgres gripes, while I work on the worst designed oracle database of all time.