Oracle Enterprise Manager vs Quest Foglight for Databases comparison

Oracle Enterprise Manager vs. Quest Foglight for Databases

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

Oracle Enterprise Manager

Ranking in Database Development and Management

1st

Average Rating

8.4

Reviews Sentiment

6.9

Number of Reviews

125

Ranking in other categories

Server Monitoring (4th)

Quest Foglight for Databases

Ranking in Database Development and Management

4th

Average Rating

8.4

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of December 2024, in the Database Development and Management category, the mindshare of Oracle Enterprise Manager is 6.8%, down from 9.4% compared to the previous year. The mindshare of Quest Foglight for Databases is 7.6%, up from 7.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Database Development and Management

Featured Reviews

Muhammad Usman Muzaffar

Senior Vice President IT Operations at ZTBL

Provides good stability and has an easy implementation process

It is a good tool for monitoring databases. It enhances the overall visibility within the database The older version of the product works with Flash technology. Although the latest version works with Java, it still requires Flash technology. It should utilize only a Java plugin to visualize your…

Read full review

Vadim Kulikov

Senior Engineer at a computer software company with 11-50 employees

Excels at displaying intensive database queries and enables me to address things before they become real problems

Foglight does have a component that allows you to look at things in real time, but it's not as friendly or as efficient in terms of responsiveness as Quest Spotlight is. Foglight might be lacking in this department. It could be just the nature of the beast, it could be the fact that it's web-based, as opposed to Spotlight being a fat client running on C#. I use both tools in conjunction with each other; they are a part of the toolset. Foglight might not be as helpful. It's also possible that part of the issue is how Foglight is deployed. We always try to save on cost and because it requires a SQL license, you don't necessarily have the luxury of putting it on a super fast server. It could be related to that. But I have noticed that it's not as responsive for determining, in real time, what's going on. The way I have understood things is that there was an attempt to merge Spotlight functionality with Foglight. They have somewhat done that, even though I still feel that they're not going to be able to completely kill Spotlight. That tool is done so well and it's really serving a purpose in terms of a real-time, very fast analysis of multiple metrics. I don't like what they did with Foglight because it's an attempt to merge. It's like a sports car versus a heavy-duty truck. They are both fantastic, but when you try to jack up a truck to work fast, it doesn't work very well.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"We use Oracle Enterprise Manager as a tool to monitor Oracle products."

"Some of the most valuable features are its real-time performance view/dashboard, metric history, real-time monitoring and alerts, as well as quick access to Oracle's tuning and diagnostic options."

"The most valuable features of Oracle Enterprise Manager are the data guide and online monitoring."

"The solution's most valuable feature is the ability to examine SQL code, track how many times it’s been parsed and used, and utilize this data for tuning."

"The dashboards are great for gathering analytic information and seeing where the problems are."

"I have found the uptime of all of our systems to be most valuable with this solution. This is important because we need to guarantee specific uptime and preventive maintenance. We need to know upfront if there are going to be any issues on the database so we can proactively solve those."

"It is a stable solution...The initial setup of Oracle Enterprise Manager was straightforward."

"The most valuable feature is high availability."

More Oracle Enterprise Manager pros

"The ability to monitor multiple database platforms streamlines our database operations. The single pane of glass is what we were really after when we picked Foglight. We knew we wanted something that could monitor cross-platform because it does save a lot of time to use the same tool. The one thing that I like with Foglight is that we don't have to install anything locally, like agents, directly on the database servers. That was also a big seller because it simplifies things."

"We can visualize all the different types of DB servers that we are monitoring in a single pane of glass. It uses a 360-degree overview of the database, for each of those databases that we are monitoring. That includes what kind of resource utilization is happening and what kind of DB parameters are getting monitored, as well as the different types of DB parameters that are being offered for each database type."

"The PI module allows [my colleague] to identify which new indexes or modified indexes are going to make the biggest impact."

"The alarms alert proactively if there are any potential or ongoing issues with the databases that we support. That means we can take preventive or corrective action before the issue becomes a big issue. And the SQL PI features enable us to drill down into performance issues in our databases so that we can improve performance, which is important."

"The most valuable feature is the in-depth capability SQL Performance Investigator provides. It allows you to drill down to the smallest detail that occurs on our platform. It does a highly detailed and atomic follow-up of what one wants to look for in relation to time and our different instances."

"Foglight's Change Tracking capabilities are another huge feature. It is wonderful to be able to do that. People don't realize the amount of information that Foglight gathers from a given server or instance. It gets down to the version of SQL, the disk array, everything that's there. Any change that's made, any upgrade to SQL, shows up on the dashboard almost immediately. You don't know how much time you save just having a tool in your back pocket that does that for you."

"What I really like is the SQL PI feature, which allows us to drill down into queries and identify what is causing contention in the database. Using the SQL PI feature, I am able to drill down into the queries, see what is blocking, and try to improve it."

"Its reporting capabilities are immense."

More Quest Foglight for Databases pros

Cons

"There's a lot of documentation to go through as a new user."

"Improving the integration speed would be beneficial, as the current Java-based system can sometimes result in slow responses."

"It needs to support the Database versions lower than 10.2."

"I would like to improve the cost."

"It is complicated to run it on Google Chrome."

"The tool's pricing is costly."

"The platform's interface could be more streamlined. Currently, there are multiple ways to navigate to a specific point, which can be confusing."

"My opinion is that this solution needs to improve consolidation. That is what our business needs the most right now."

More Oracle Enterprise Manager cons

"Quest must release a Spanish version. That's critical because not everyone speaks English in Latin America. It's an excellent product, so it's super important that they offer the application and customer service in Spanish."

"I get a lot of alerts that, while important, are not critical. Then I have to dig in and figure out how to turn alerts off, but not the logging. I want to be able to go back, once we get the other big issues out of the way, and start fine-tuning some of those other areas, but I don't necessarily want to receive an email for all of them."

"When holding data for two years for 20 SQL Servers, the reporting becomes sluggish and unresponsive."

"Better communication and alerts regarding the transaction logs getting full would also be beneficial. What I have noticed is that if the log files on the SQL server are full, we cannot log in and have to do some cleanup on the Foglight DB. It would be good if they could monitor that and alert us when it is getting too full."

"I would like the rule development code to be made available so we don't always have to be referred to professional services for custom solutions. For example, if we want to exclude certain databases from a particular rule, we shouldn't have to go to support and to professional services for that solution. If the code and syntax were available, we have resources that could quickly turn something like that around."

"Foglight does have a component that allows you to look at things in real time, but it's not as friendly or as efficient in terms of responsiveness as Quest Spotlight is. Foglight might be lacking in this department."

"The data model needs improvement when it comes to creating custom reports. That is an area where it needs a bit of improvement. Foglight gathers a lot of information around our databases as part of its monitoring. While I know all this information is in there, trying to pull the metric we want out for custom reports is sometimes hard to find. One nice thing about Foglight is that you can create custom dashboards, which you can easily convert to reports. We would be doing a lot more of that if it weren't for the challenging data model."

"The version that I'm using is not the latest version, so there might have been some improvement, but the OS monitoring is a bit lacking, and the high-availability option is a bit complicated to set up and it doesn't work all the time."

More Quest Foglight for Databases cons

Pricing and Cost Advice

"Oracle Enterprise Manager is a free tool from Oracle."

"The solution is inexpensive to purchase."

"Based upon 3 days of implementation by a single person, plus licensing costs would be approximately $60,000, including the virtualized hosts."

"The product is highly-priced."

"I rate Oracle Enterprise Manager’s pricing a five out of ten."

"Initially, our deal was for three years, and we extended it to five years. Oracle solutions are very costly."

"The basic functions are free. You only pay license fees for advanced features."

"There is only the standard licensing fee. There are no other costs."

More Oracle Enterprise Manager pricing and cost advice

"The price of Foglight could be a little more competitive in Chile, and it should be lowered for long-time customers— at least by 20 percent. Sometimes the price is a limitation. We have seven instances and nearly 5 million users. If Quest Foglight could reduce its prices for the clients that have been with it for a long time, we would be able to have more instances."

"This is like the "Cadillac" of performance monitoring software. It's not cheap... I am currently with a company that I was able to convince that the product is worth the cost."

"The price is worth it, if you have the time to go through the information."

"Compared to the other tools on the market, Foglight is okay in terms of pricing and licensing."

"It is cost-effective. With our EA, it is really based on the scale of our database environment. We found the Quest team to be reasonable and flexible when it comes to pricing and scaling of licenses."

See which vendors are best for you

Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.

See recommendations

824,053 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Educational Organization

76%

Financial Services Firm

Computer Software Company

Government

Computer Software Company

15%

Financial Services Firm

13%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Oracle Enterprise Manager?

What I like most about Oracle Enterprise Manager are its features, particularly the active session history. It provides insights into SQL, and I use it regularly to identify potential issues.

What is your experience regarding pricing and costs for Oracle Enterprise Manager?

The licensing is based on the core, and it is required to have a server for the solution.

What needs improvement with Oracle Enterprise Manager?

Setting up the Oracle Enterprise Manager is challenging as it requires setting up a separate server.

What is your experience regarding pricing and costs for Quest Foglight for Databases?

The price of Foglight could be a little more competitive in Chile, and it should be lowered for long-time customers— at least by 20 percent. Sometimes the price is a limitation. We have seven insta...

What needs improvement with Quest Foglight for Databases?

Quest must release a Spanish version. That's critical because not everyone speaks English in Latin America. It's an excellent product, so it's super important that they offer the application and cu...

What is your primary use case for Quest Foglight for Databases?

We use Foglight for database engines and Google servers. We use it in a private cloud, our cloud provider is Google Cloud Platform. Foglight is centralized in our data center, from there, we send i...

Zabbix vs Oracle Enterprise Manager

Comparisons

Compared 18% of the time

Dynatrace vs Oracle Enterprise Manager

Compared 12% of the time

AppDynamics vs Oracle Enterprise Manager

Compared 10% of the time

Nutanix Database Service vs Oracle Enterprise Manager

Compared 7% of the time

Toad for Oracle vs Oracle Enterprise Manager

Compared 5% of the time

More Oracle Enterprise Manager Competitors

Quest Spotlight vs Quest Foglight for Databases

Compared 41% of the time

SolarWinds Database Performance Analyzer vs Quest Foglight for Databases

Compared 32% of the time

Redgate SQL Toolbelt Essentials vs Quest Foglight for Databases

Compared 5% of the time

SQL Sentry vs Quest Foglight for Databases

Compared 5% of the time

IDERA SQL Diagnostic Manager for SQL Server vs Quest Foglight for Databases

Compared 5% of the time

More Quest Foglight for Databases Competitors

Product Reports

Oracle Enterprise Manager

Download Oracle Enterprise Manager product report

Quest Foglight for Databases

Download Quest Foglight for Databases product report

Learn More

Oracle

Quest Software

Overview

Oracle Enterprise Manager is an on-premises management platform that provides a comprehensive integrated solution for managing and automating your various Oracle products, including applications, databases, middleware, hardware, and engineered systems located either in your Oracle data center or in the cloud.

With the Oracle Enterprise Manager's console, you can administer multiple databases and servers, distribute software to multiple servers and clients, monitor objects and events throughout the network, and integrate with other tools.

Key Oracle Enterprise Manager Features and Products

Hardware and virtualization management: Manage all Oracle environments from one central console. Oracle Enterprise Manager provides management and automation for Oracle engineered systems, databases, middleware, and hardware.
Database management: Oracle’s Database management provides a full lifecycle solution for updates and configuration management, patching, provisioning, testing, performance management and automatic tuning.
Application performance management (APM): User and database monitoring with diagnostics and performance analysis that provide rich reporting on real user activities.
Enterprise monitoring: Built-in monitoring of all components of the IT infrastructure enables rapid problem diagnosis. Both Oracle and non-Oracle components are constantly monitored.
Oracle real user experience insight: Insights on real user experiences and preferences enable businesses and IT stakeholders to develop a shared understanding into their application users’ experience.
Non-Oracle management: Oracle Enterprise Manager manages non-Oracle components with a comprehensive set of plugins. The self-update mechanism allows customers to download, import, and deploy extensions built by Oracle, Oracle partners, and Oracle customers. These extensions enjoy the same level of stability as Oracle's own products.
Installation and upgrade: The upgrade process provides efficient, reliable, secure data migration with minimal downtime of your environment.

Reviews from Real Users

Oracle Enterprise Manager stands out among its competitors for a number of reasons. Several major ones are its central management and monitoring and its reporting capabilities

Robin C., head of Oracle Exadata Centre of Excellence at Tata Consultancy Services, writes, "The database performance monitoring features are very useful and allow us to quickly zero in on DB-related issues. Exadata storage server and Infiniband switches can be viewed from the GUI in OEM which cannot be done in other tools. The ability to deploy metric extensions makes this tool extensible for our custom monitoring also."

PeerSpot users note the effectiveness of these features. A database manager at a tech services company notes, “The solution's most valuable aspect is the fact that it is embedded with the Oracle database and Oracle's engineering system, its extra data, and analytics. They have plug-ins that are very helpful. Due to the infrastructure's size, the introduction they offer is very, very useful. It helps with an overall understanding of the product. They have a very nice graphical user interface. The monitoring is good. We can capture the SQL tune from us. With Oracle Enterprise Managers, we can see the rich performance tuning.”

Foglight identifies and resolves performance issues across your applications, databases and virtual environments. The Foglight family of products easily integrates with your existing tools, so you can monitor and analyze data from almost any source across your infrastructure and view it through a single interface with our customizable, unified monitoring platform

Sample Customers

7-Eleven, Halliburton, Cisco, Garmin, Nationwide, Korea Telecom, Allied Irish Bank

CommitDBA

Oracle Enterprise Manager vs. Quest Foglight for Databases