I made best expieriences with Spotlight on Oracle ( Quest Software ) . For Instance-Tuning and for SQL-Tuning. You can fast idnetifiy instance-Bottlenecks and poor sql-STMT The best GUI for DatabaseTools i ever seen. The Tool is not so good for backround-Tuning! /Karl IWatch is invasive and can degrade performance on an OLTP database; otherwise, it is an excellent tool. Spotlight does what you want, but OEM can also. Using it in a large conversion effort, I found Spotlight (formerly Instance Monitor) to be excellent. Besides having great graphics, it provides a valuable Help facility that every DBA can learn from. Fortunately, I don't deal with money issues. fyi, we also use Precise (which offers historic tracing of SQL) and a bit OEM (which is much more cumbersome than Spotlight). We've trialled it - and you're right it looks pretty good. We are purchasing it along with another Quest product (I/watch) for around $18K. Haven't used other monitoring tools so can't compare. Regards, Martin [Yong's note: K. Hailey is an Oracle employee, a very technical guy I always trust] From: hailey_kyle AT my-deja.com (hailey_kyle AT my-deja.com) Subject: Re: Quest Spotlight for Oracle... Newsgroups: comp.databases.oracle.server Date: 2001-01-23 14:20:07 PST I think it is really cool - probably the best monitoring tool I've seen for Oracle. Certainly better than OEM. OEM is so heavy and clumsy. With Quest thing, you just pop it on the windows box, it prompts you to create a user and then you start monitoring. I found the choice of things to monitor right on the money and the general design pretty ergonomic. THe only peeve I have is that it isn't (or wasn't when I saw) extensible and there was no option to log the stats to files. After seeing the Quest monitor, it inspired me to write a monitor in TCL/TK where I could save the raw data to files. Its on www.geocities.com/oraperf if you are interested in looking at it. The only thing I really use it for is monitoring wait events verses CPU usage which is the heart of monitoring an Oracle database. I also monitor sys stats and top user, but I haven't added the drill down onto users which is pretty cool, but not a big priority for me since I run a session pool so there are no real users - everyone shares all the connections. Best Kyle From: Raj Mandair (raj AT halcyoninc.com) Subject: Re: Spotlight on Oracle / Instance Monitor Newsgroups: comp.databases.oracle.tools Date: 2000/10/20 If you are using Sun Management Center to monitor your enterprise, you can look at the PrimeAlert for Oracle module that is available from Halcyon Inc. Sun Management Center can be downloaded from http://www.sun.com/sunmanagementcenter and the PrimeAlert for Oracle Module can be downloaded from http://www.halcyoninc.com/downloads for a free 30 day trial. The Sun Management Center Java front end has very acceptable performance on modern Solaris and NT boxes. Halcyon Inc also offers a PrimeAlert WebPortal module which is a web based front end. I'm afraid we are still looking for a decent monitoring tool. OEM was fine up until the days they converted it to Java - now we need a spalsh screen to tell us the splash screen is loading :o( I used a previous incarnation of OEM on my Oracle Tuning course and was well impressed, recommended it at work, bought a licence and found we had the latest and greatest Java version. Slow and clunky is not the word - totally unusable comes close though. I am very disapointed :o( Regards, Norman. ------------------------------------------------------------------------ -------- Norman Dunbar EMail: NDunbar AT LynxFinancialSystems.co.uk Glen Stromquist wrote: >I just tried Quest's Spotlight on Oracle, formerly Instance Monitor, it >seems like a very slick product, fast & sleek compared to OEM, which I >find slow & clunky, albeit very powerfull. Haven't used either of them >enough yet to do a fair comparison, anyone care to start a discussion >on this? > I use both. For performance issues Spotlight is my first choice. We just purchased a licensce. For stuff like looking at schemas and security definitions I use OEM. I read that OEM is improved in 8.1.7. You are correct about slow and clunky. From: Robert Malikian (robert_malikian AT zdnet.com) Subject: Re: Quest Spotlight for Oracle... Newsgroups: comp.databases.oracle.server View complete thread Date: 2001-01-23 10:00:50 PST Yes it is a good tool. My manager and all development team like SPOTLIGHT because it so colourful. But the joke apart it gives you a good view of that happening in the database. Robert Malikian Oracle DBA Subject: RE: Quest Software's Spotlight on Oracle & Oracle Applications From: "Harsha Hegde (OCS-BLRAKS-MIT)" Date: Tue, 24 Apr 2001 14:49:54 +0530 Spotlight on Oracle is a good Monitoring Tool that can be installed on a Windows machine. The results which are obtained from the tool is quite satisfactory Regds... Harsha -----Original Message----- From: SA [mailto:milasuk AT aol.com] Sent: Monday, April 23, 2001 7:30 AM To: OAUGnet-DBA Subject: Quest Software's Spotlight on Oracle & Oracle Applications Hi all, Does anyone have any experience / knowledge on Quest Software's Spotlight on Oracle and Spotlight on Oracle Applications? I am most interested in hearing your review of the software. Thank you in advance. Regards, Sukma Subject: RE: Quest Software's Spotlight on Oracle & Oracle Applications From: "Sacca, Robert" Date: Tue, 24 Apr 2001 07:14:08 -0400 I would look into Precise software ( www.precise.com ) We have been using the entire suite of there tools since August and are extremely happy. Plus, their tools have a performance warehouse that keeps historical performance data....very handy. I can't say enough how happy we are that we chose Precise over Quest. (No I don't work for them...:o) Robert Sacca Manager, Database Services Research Foundation of SUNY F216 SUNY Plaza - Broadway Albany, NY 12246 (518) 434-7206 email: bob.sacca AT rfsuny.org