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:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).