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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Minh Nguyen
Sent: Wednesday, April 21, 2021 1:53 PM
To: oracle-l@xxxxxxxxxxxxx
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.