RE: Recommendation for Oracle Monitoring tool

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Wed, 21 Apr 2021 20:25:05 +0000
Message-ID: <DM6PR11MB271581EA470316A97B1B48A6D4479_at_DM6PR11MB2715.namprd11.prod.outlook.com>



I've had good luck with DPA from Solarwinds (we bought it when the product was Ignite from Confio). Solarwinds bought Confio and renamed it to Database Performance Analyzer. We use it for both Oracle and SQL and it's nice to have a single interface for all the DBA's (all 2 of us! :) ). It is focused on wait times as opposed to things like space or alerts, though you can write custom scripts for some of that.

Regardless, I would certainly seek at least a 2 week demo license from any vendor. Seems like all the tools are better once they know a little about your database(s).

-joe

p.s. Oh - standalone DPA is not part of the Orion product and was not compromised. Just in case you're wondering.

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Minh Nguyen Sent: Wednesday, April 21, 2021 1:53 PM
To: oracle-l_at_freelists.org
Subject: Recommendation for Oracle Monitoring tool

Hello Everyone,

I am looking for firsthand experience recommendation for Oracle monitoring tool. If you can specify what you like about it versus OEM that would be great.

We have over 3000+ Oracle and Sql Server that we monitor. We currently use OEM for Oracle and SCOM for SQL Server.

We uses OEM for monitoring, performance tuning, as well as scheduling backup and probably a bunch of other stuffs that only a few people knows about.

I am perfectly happy with OEM, but management wants to know so here we are.

Management was wondering if there are better tools out there, for monitoring Oracle DB, that we should evaluate? If it can do SQL Server as well then it would be a big plus. If not, then not a big deal. I am more interested in the Oracle side.

Not sure why we didn't use OEM plug in for SQL Server. Nobody seems to know the answer.

Last thing I saw through the list archive is that QUEST was taking over the world by acquiring all the competitors and BMC was the only big competitor standing. Is what Kyle Halley said in 2011 stills valid? "OEM and Foglight seem like the best" https://www.freelists.org/post/oracle-l/OEM-vs-Foglight,4<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.freelists.org%2Fpost%2Foracle-l%2FOEM-vs-Foglight%2C4&data=04%7C01%7CJSweetser%40icat.com%7C2f9a5fe21fea43784b8208d904ff1019%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C1%7C637546315816765978%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=OtNbrAdk9y4noMisOBNJCPCUUGLxV8gB%2BCHD6u107rk%3D&reserved=0>

Thanks!
Minh Nguyen
Oracle Database Administrator

This e-mail transmission and any attachments that accompany it may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law and is intended solely for the use of the individual's to whom it was intended to be addressed. If you have received this e-mail by mistake, or you are not the intended recipient, any disclosure, dissemination, distribution, copying or other use or retention of this communication or its substance is prohibited. If you have received this communication in error, please immediately reply to the author via e-mail that you received this message by mistake and also permanently delete the original and all copies of this e-mail and any attachments from your computer. Please note that coverage cannot be bound or altered by sending an email. You must receive written confirmation from a representative of our firm to put coverage in force or make changes to an existing policy.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 21 2021 - 22:25:05 CEST

Original text of this message