Re: Newbie's Oracle 9i impression: it sucks

"SQLJoe" <sqljoe_at_aol.com> wrote in message news:20020521140706.02455.00000092_at_mb-mu.aol.com...
> I think you mistakenly believe I am a MS SQL zealot. I am far from it. In
fact,
> I will admit to all its flaws and shortcomings. What I am saying is Oracle
has
> some glaring shortcomings which I find almost shocking. Also, I am
learning DB2
> right now. So I am not stuck nor have affinity toward only one product.

However just to recap the only 'shortcomings' you referred to were

1)Oracle is SLOW on Windows2000, FAR slower than MS SQL 2000

Untrue

2)Oracle uses Java interface which, although cross platform, is slow and brings
out the DOS prompt (which remind of legacy applications) everytime I try to open up a GUI.

Untrue

3)Believe ir not, Oracle is unstable and unreliable on Windows2000. I had Oracle GUI crash on me TWICE already.

subjective.

4)Oracle security is overdone. It has multiple layers of security on the network level to the application level. Initially, I had a hard time enterting
any database, and it took me while to setup the security features.

misconception. its not overdone and you can delegate to the os.

4)Setting up a Oracle Client is a nightmare. I need to setup a listener, port,
and separate account\pw for the client. Too much work.

Untrue. same details are required by mssql.

5)The official Oracle books from the Osbourne press absolutely SUCKS. I have read 3 books on Oracle 9i from the Osbourne press and all of them were next to
useless. Furthermore, there are very few non-Osbourne books on Oracle 9i that I
can currently buy. This is in stark contract to MS SQL 2000 which has PLENTY of
GREAT books and documentation (except the ones from OSBOURNE).

Some merit to this. These are of course 3rd party products and apparently you couldn't be bothered to RTFM.

6)Oracle is too complicated. I am willing to bet most Oracle DBA\Developers never use at least 20% of Oracle's features in their entire career. It seems Oracle has a GUI for every little feature it provides, which makes it seem disorganized and a nightmare to manage. I think it has around 20 GUIs!!!!. For
a database, that is ridiculous.

Untrue.

7)PL/SQL is overrated. So far, I have seen nothing that PL/SQL can do which T-SQL (with temporary tables and cursors) cannot do. Why would anyone want to
learn a SQL language that is, again, needlessly complicated?

Opinion not fact.

So on my reckoning 4 out of your 7 statements were untrue, 2 referred to matters of opinion and one referred to a third party's products. if these are the glaring and shocking shortcomings then I rather suspect the conversation is dead.

--
Niall Litchfield
Oracle DBA
Audit Commission UK