RE: TOAD vs BMC's XRAY

For development, take a look at Allround Automations Pl/Sql Developer. Nice functionality and an affordable price (~$50 in bulk).

http://www.allroundautomations.nl/

From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>@fatcity.com on 07/22/2003 09:24

       AM PST Please respond to ORACLE-L_at_fatcity.com

Sent by: ml-errors_at_fatcity.com

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> cc:
Subject: RE: TOAD vs BMC's XRAY

I haven't used DBXray (yet -- maybe it's not an automated process to download a trial?), but I don't feel TOAD is the best at DB administration, especially for performance tuning/monitoring. Then again, it's been awhile since I've used TOAD's optional DBA module, since it's no longer available in the beta. For development, I think it's the best, especially at US $795/user. I've been a TOAD user since v4, when it was Jim McDaniel's freeware baby.

For tracing into running SQLs I prefer using Quest's Spotlight. Aside from a slick interface (makes impressive screen shots for management-types), it is very easy to drill down into problem areas, like resource hogging sessions you mention. I still think that any tool requires knowledge of the underlying queries they use to fully understand what the tool is telling you, I just happen to prefer Spotlight's interface.

If I ever get the email for the DBXray trial from BMC, I'll let you know what I think of that compared to the others.

> -----Original Message-----
> From: Fermin Bernaus [mailto:fbernaus_at_sammic.com]
> Sent: Tuesday, July 22, 2003 11:20 AM
> To: Multiple recipients of list ORACLE-L
> Subject: TOAD vs BMC's XRAY
>
>
>
> Hi there,
>
> I am considering buying an administration tool and
> programmer's tool. The two I know are Toad and BMC's XRAY but
> since I do not know them very well I have difficulties
> deciding which of them is the best. What I need more is to
> tune the database, trace into time and CPU consuming SQLs, a
> procedure / trigger editor and debugger.
>
> Or maybe you know better tools than these two... any
> help will be greatly appreciated.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).






American Express made the following
 annotations on 07/22/2003 10:23:05 AM
------------------------------------------------------------------------------
******************************************************************************

     "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited.  If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments.  Thank you."

******************************************************************************