great review :) I told them the same thing, but they're developer driven. The customer using the product comes 2nd. A flashing widget is more important to them than useful data to the DBA. The slowness has a been an issue since web dba. That required 256mb of ram. I asked if they were going to include memory and they said everybody runs their desktop with 500meg of ram or even better "They'll need to upgrade". :))
my 2� ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 1:49 PM > OK, I got the e-mail to try a trial of DBXray from BMC. Crap, I tell you. > Crap. Crap, crap, crap. To be truthful, I'm not sure how much we pay for > Spotlight, but for $2500/user, DBXray has a LOT to be desired. > > I've apparently been spoiled by Quest's Spotlight interface. After a > 15-minute trial of DBXray (granted, that's a little slim), here's what my > kneejerk of what I see to be the advantages of Spotlight on Oracle (SoO) > over DBXray (DBX): > > 1) It's in freakin Java. 60MB of mem to launch and it's sloooow, even on a > 2.4Ghz w/512MB. Half of this is a Java Windohs service. > > 2) It doesn't understand ONAMES, so I would need to manually maintain yet > another repository of Oracle Network connections. > > 3) SoO's color scheme is configurable. DBX seems to be fixed on a scheme of > light gray on light blue. Very low contrast and I can't imagine this is > viewable by color-blind folk. > > 4) SoO's interface is scalable. DBX's main dashboard is fixed in size. > > 5) No menu access to drilldowns in DBX. Difficult for neophyte or > occasional users to locate the correct image map on the main dashboard of > DBX. > > 6) Session drilldown has fixed set of columns in DBX. "Tune" button only > provides weak text-only explain plan. SoO provides two different methods > for doing explain plans out-of-the box, and is expandable with optional > software like the-product-formerly-known-as-SQLab. > > 7) Very few options for data display in DBX. SoO, for example, allows you > to turn off BCHR collection as well as configure which columns to return > from V$SESSION for the session drilldown (see #6). > > Man, there's so much more I don't want to take more time on it. SoO is > clearly a *far* superior product when it comes to instance monitoring and > tuning. I tried thinking of a single advantage of DBX over SoO, and I can't > come up with one. > > Now to see if DBX will actually uninstall... > > > Rich > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > p.s. Jacques, you can tell Steve N (Quest Monitoring Product Manager) that > I'm a "large" for Quest t-shirts, polos, and/or jackets. ;) > > > > -----Original Message----- > > From: Jesse, Rich > > Sent: Tuesday, July 22, 2003 11:27 AM > > To: '[EMAIL PROTECTED]' > > 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:[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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Perry 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).
