Quest Foglight for Databases vs Toad for Oracle comparison

Quest Foglight for Databases and Toad for Oracle are both solutions in the Database Development and Management category. Quest Foglight for Databases is ranked #4 with an average rating of 8.3, while Toad for Oracle is ranked #5 with an average rating of 8.7. Quest Foglight for Databases holds a 7.8% mindshare in DDM, compared to Toad for Oracle’s 6.0% mindshare. Additionally, 93% of Quest Foglight for Databases users are willing to recommend the solution, compared to 100% of Toad for Oracle users who would recommend it.

Quest Foglight for Databases

Read 13 Quest Foglight for Databases reviews

2,284 Views
883 Comparison Views

93% willing to recommend

Toad for Oracle

Read 16 Toad for Oracle reviews

1,488 Views
685 Comparison Views

100% willing to recommend

Quest Foglight for Databases

Toad for Oracle

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jan 23, 2025

Quest Foglight for Databases and Toad for Oracle both compete in the database management software category. Based on the data, Foglight has the upper hand in terms of features, while Toad for Oracle shows strength in specific Oracle optimizations but needs enhancements.

Features: Quest Foglight offers adaptive baseline monitoring, Performance Investigator, and supports multiple database platforms including Oracle and SQL. It provides real-time activity screens for proactive alerts. Toad for Oracle is known for its PL/SQL debugger, a comprehensive code formulation tool, and dedicated Oracle environment optimization features, such as the session and schema browsers.

Room for Improvement: Quest Foglight needs better performance with large datasets, improved customizable alerts, and application performance monitoring. Toad for Oracle could enhance query optimization, simplify its user interface, and improve the speed of operation while refining error code management.

Ease of Deployment and Customer Service: Both products primarily offer on-premises solutions with cloud capabilities. Quest Foglight is praised for proactive Premier Support, bolstering user satisfaction, while Toad for Oracle's support, although strong, sometimes experiences delayed responses.

Pricing and ROI: Quest Foglight is costly, yet provides significant ROI by preventing downtime and improving performance visibility. It helps maintain operational continuity, offering extensive time-saving features. Toad for Oracle, while expensive according to some users, delivers cost-saving productivity features and suggests the need for pricing enhancement.

To learn more, read our detailed Quest Foglight for Databases vs. Toad for Oracle Report (Updated: January 2025).

Buyer's Guide

Quest Foglight for Databases vs. Toad for Oracle

January 2025

Download the complete report

Helped 832,138 peers since 2012

Review summaries and opinions

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

Categories and Ranking

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

Toad for Oracle

Ranking in Database Development and Management

5th

Average Rating

9.0

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of February 2025, in the Database Development and Management category, the mindshare of Quest Foglight for Databases is 7.8%, up from 7.1% compared to the previous year. The mindshare of Toad for Oracle is 6.0%, up from 5.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Database Development and Management

Featured Reviews

Eric Fouarge

Global Head of Engineering for Cloud Operations at SAI Global Compliance

We have complete visibility into multiple database platforms, but we'd like better insights into Postgres

We had some licensing constraints with our previous solution Idera. When we crafted the contract with Quest on Foglight, we were able to go from basically 30% coverage of our production environment to 100% coverage. We have better visibility into the environment since putting it in place. We implemented the solution’s Angular UI. It took us a day to do it, and we just stepped in and started using it. It was pretty straightforward and easy. The overall data availability in the Angular UI is good. We are not seeing any gaps from the legacy UI to the new UI for the things that we were relying on. Everything that we expected to be there is there. It proactively alerts us of long-running queries. In terms of the capability to quickly diagnose and resolve emerging issues, some things are disconnected from the rest of our observability platform. It takes a few steps to get from incident to resolution, but once we step into Foglight, we are able to quickly get to the data that we need to understand what is going on. It provides real-time activity data. We run a 24/7 shop. If there are any database performance issues, we have to act on them pretty quickly. We do not use it much to display intensive database queries. It is not really our core use case, but when we are troubleshooting application performance, it does get used in that manner at times. It enables us to drill down and see what is causing the issue to an extent. Because we run a dynamic ORM, it is a little difficult to ascertain exactly what is happening from a database query perspective, but that has nothing to do with the tool itself. It is more about how we dynamically generate the SQL queries. It enables us to monitor multiple database platforms. We have Microsoft SQL Server, Postgres, and MySQL. Prior to having Quest Foglight for Databases, we did not have anything centralized to provide this level of insight into our platform, and we now have it. It does exactly what it is supposed to do, and it does not do anything more, which is what we want. We do not want it to start venturing outside of what it is good at and what it is built for.

Read full review

Bikramjeet Singh

Senior Reg Reporting Consultant at Bank of America

Advanced query optimization and tuning features

Sometimes when I write a query, it gives an unusual error code. Toad for Oracle does not have a particular resolution within the application. Then, I have to search for the code and find a solution. I would like Oracle to implement error codes so that we don't have to search for solutions on Google. It would be more convenient if the error codes were included within the application.

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

"Foglight is also able to help the DBAs proactively fix problems before they become an issue. It provides them with real-time activity screens that help in this regard. The DBAs are able to go to these screens and look at what's happening in real time, and that buys them time. It helps them see problems ahead of time and find solutions to them."

"We went from basically 30% coverage of our production environment to 100% coverage."

"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 PI module allows [my colleague] to identify which new indexes or modified indexes are going to make the biggest impact."

"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."

"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."

"Its reporting capabilities are immense."

"The profiler allows us to look at the profiles of the database queries that are being run over time. It allows us to go back to our customers and say that these are some of the queries causing them some headaches. It gives us the opportunity to provide suggestions on how to improve their experience."

More Quest Foglight for Databases pros

"The best product for working with Oracle databases for support, checking and loading data."

"The most valuable feature is the navigation within the UI, where you can right-click on an object in an SQL query and go right to it, versus going through all of the menus to find what you are looking for."

"It is very easy to manage all of the objects."

"The product's most valuable features are UI and monitoring."

"The schema browser is the most valuable feature. The way it presents the objects in our database."

"Toad for Oracle has proven to be better than other tools since we have never experienced any crashes."

"I like that it's very flexible and helpful in query accuracy, analysis, and data visualization. I also like the move facilities available in Toad for Oracle. Overall, I think it's a fantastic product for analyzing SQL queries and managing all kinds of queries."

"I haven't seen any issues with scalability. We have about 1000 people on our IT team who use the solution."

More Toad for Oracle pros

Cons

"One thing that I would like, and it's probably something that I could set up internally, is something other than a dashboard which I have to look at to know that a server is down. I'd like bells and whistles to go off... If I look at the dashboard I know there's a server down. But if I'm not looking at it, if I'm looking at some other problem, I want to know about it. You can do that, you can use SMSs and alerts to your phone, and I could set it up to handle that, but it would be nice if, out-of-the-box, Foglight did that."

"The monitoring capabilities for Postgres should be at par with SQL Server. This is the area where we push back on our Quest representative."

"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."

"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."

"When we decided to go with Foglight, a lot of people stopped using the diagnostics part because it was very intimidating... They still won't use it because they feel it's too intimidating. They will open something up and not know what to do. It's not very user-friendly. You have to click on a lot of stuff to find the information."

"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 system is not that stable. We have been facing a lot of issues. We built a new store environment of Foglight, an environment for monitoring the Lowe's store servers, which are all Db2 servers. The objective is to monitor 800 Db2 servers in each Foglight instance. Up to 150 Db2 servers, the environment was working fine. The moment it crossed 150 or 160, we started having a lot of stability issues."

"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."

More Quest Foglight for Databases cons

"There should also be a better "cancel query" option as sometimes one cancels a query, but then it still might run for a long time, and then one has to crash Toad in order to cancel the query."

"Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another."

"There may be an issue with processing limitations but this cannot be confirmed as a problem with the product or with the newest releases."

"I would like to see an improvement in the performance because opening the browser and the editor should be faster."

"The way the dialog boxes appear can be improved."

"Toad for Oracle does not have a particular resolution within the application."

"It would be beneficial if Toad for Oracle could incorporate OEM features, as having monitoring capabilities in the same interface would simplify workload and management tasks."

"An area where the solution could use some improvement is in terms of user-friendliness. During the initial setup phase, the solution was not very intuitive when attempting to establish connections."

More Toad for Oracle cons

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."

"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."

"Pricing is very reasonable. We were able to construct a pretty easy contract with Quest, who were very easy to work with and very amenable to what we are trying to do. It worked out well for us."

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

"Toad for Oracle has a relatively high cost compared to other similar tools."

"There are paid and free-for-use versions of the product."

"The product's pricing is just right because if it were slightly higher, it would not have been as widely adopted as it currently is in our organization."

"The pricing is okay, it's reasonable."

"My advice is to try to use the three-year maintenance agreement if possible."

"The professional edition is about $1,000 AUD ($700 USD) and the developer version is about twice that much."

"In my opinion, this solution is a little expensive, but I understand that good programs cost more money."

"I would rate it six, where one is a low price, and ten is a high price."

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

832,138 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Computer Software Company

15%

Financial Services Firm

12%

Government

Manufacturing Company

Financial Services Firm

20%

Government

12%

Computer Software Company

11%

University

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

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...

See all answers

What needs improvement with Quest Foglight for Databases?

It would be helpful to have more communication about new features. The concept of intensive database queries sounds beneficial, but I am not aware of how to access this feature. Better communicatio...

See all answers

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

We use it for monitoring SQL databases, specifically to assess database contention. Additionally, we utilize it for real-time monitoring before deploying changes to production environments.

See all answers

What do you like most about Toad for Oracle?

The product's most valuable features are UI and monitoring.

See all answers

What is your experience regarding pricing and costs for Toad for Oracle?

The licensing cost for Toad for Oracle is relatively high, with their license and DPA suite totaling around five thousand dollars.

See all answers

What needs improvement with Toad for Oracle?

It would be beneficial if Toad for Oracle could incorporate OEM features, as having monitoring capabilities in the same interface would simplify workload and management tasks.

See all answers

Comparisons

Quest Spotlight vs Quest Foglight for Databases

Compared 40% of the time

SolarWinds Database Performance Analyzer vs Quest Foglight for Databases

Compared 35% of the time

Oracle Enterprise Manager vs Quest Foglight for Databases

Compared 13% of the time

Redgate SQL Toolbelt Essentials vs Quest Foglight for Databases

Compared 6% of the time

SQL Sentry vs Quest Foglight for Databases

Compared 6% of the time

More Quest Foglight for Databases Competitors

Toad Edge vs Toad for Oracle

Compared 30% of the time

Oracle Enterprise Manager vs Toad for Oracle

Compared 16% of the time

Toad Data Modeler vs Toad for Oracle

Compared 15% of the time

Aqua Data Studio vs Toad for Oracle

Compared 14% of the time

DbVisualizer vs Toad for Oracle

Compared 11% of the time

More Toad for Oracle Competitors

Product Reports

Buyer's Guide

Quest Foglight for Databases

January 2025

Download Quest Foglight for Databases product report

Buyer's Guide

Toad for Oracle

January 2025

Download Toad for Oracle product report

Overview

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

Quest Software

With Toad for Oracle, you'll reduce costs and risks by easily ensuring the health and performance of your Oracle Cloud Platform and on-premises databases. ... On the operations side, you can automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation.

Quest Software

Sample Customers

CommitDBA

intel, ebay, uber, mars, microsoft

Buyer's Guide

Quest Foglight for Databases vs. Toad for Oracle

January 2025

Free Report: Quest Foglight for Databases vs. Toad for Oracle

Find out what your peers are saying about Quest Foglight for Databases vs. Toad for Oracle and other solutions. Updated: January 2025.

DOWNLOAD NOW

832,138 professionals have used our research since 2012.

See our Quest Foglight for Databases vs. Toad for Oracle report.

See our list of best Database Development and Management vendors.

We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.