Re: SQL Server, Oracle or Informix

From: Patrick Dean Rusk <ruskies_at_mediaone.net>
Date: Sat, 03 Feb 2001 04:40:45 GMT
Message-ID: <hZLe6.4010$fa2.151788@typhoon.ne.mediaone.net>

> http://otn.oracle.com
> http://otn.oracle.com/docs/products/oracle8i/doc_index.htm
>

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76992/toc.htm

I've downloaded the whole lot and spent some time with the HTML versions, too. As I said, they are definitely quite comprehensive. I only wish they were searchable.

I haven't worked my way through Oracle's complete tuning document. It's immense (646 pages), and it looks very complete. Interestingly, it seems organized much like the O'Reilly book. I've wondered if the Oracle doc is good enough now that there isn't enough reason to make a third version of the O'Reilly book.

On your word, I will continue my journey through it.

> > 2) What is a highly regarded and affordable Oracle administration tool?
Of
> > the shareware ones I've tried out, TOAD and EZSQL seem pretty good, the
> > latter being *much* less expensive.
>
> Well - YMMV, but have a look first at DBA Studio in the Oracle DBA
> Management Pack
> http://www.oracle.com/ip/deploy/database/system_mgmt/index.html

I've worked with it. It's comprehensive, but a major pain to work with, being a bloated Swing application. Do you know if there's a way to plug in the latest 1.3 JRE in place of Oracle's 1.1.x JRE to eek out some better performance from it?

Thanks for your comments.

Pat Received on Fri Feb 02 2001 - 22:40:45 CST