Oracle Enterprise Manager and Quest Foglight for Databases are competitive solutions in database management and monitoring. Oracle Enterprise Manager gains an advantage in environments heavily invested in Oracle technologies, while Quest Foglight supports a broader range of database environments effectively.
Features: Oracle Enterprise Manager provides SQL Tuning Advisor, ADDM, and integration with Oracle technologies, aiding detailed performance analysis and administrative tasks. Quest Foglight offers real-time monitoring, adaptive baseline monitoring, and performance analysis across various databases, making it versatile in mixed database environments.
Room for Improvement: Oracle Enterprise Manager faces challenges with complexity, frequent updates, and performance scaling in mixed systems. Users seek easier patch management. Quest Foglight could benefit from improved customization options and a more intuitive user interface, alongside enhancements in alert management during high-load scenarios.
Ease of Deployment and Customer Service: Oracle Enterprise Manager is deployed in on-prem and hybrid cloud modes, requiring substantial resources but benefits from comprehensive Oracle support. Quest Foglight, often deployed in on-prem and private cloud settings, is praised for ease of use and support, though technical support response times can vary.
Pricing and ROI: Oracle Enterprise Manager is priced according to its extensive feature set and may require additional packs, being costly yet valuable in Oracle-heavy setups. Quest Foglight presents a cost-effective option with straightforward licensing, though third-party integration may increase expenses. Both solutions present proactive database management investments, with options for additional functionalities.
For root cause analysis, it definitely provides us additional capabilities of getting down to where the core issue is.
Generally, whenever we send something to them, we get a response within a few hours, and it is pretty straight to the point.
We use support when we come across issues, and they are very responsive.
Setting up the Oracle Enterprise Manager is challenging as it requires setting up a separate server.
It would be amazing if they could enable the 'Performance Investigator' functionality across all database platforms.
The monitoring capabilities for Postgres should be at par with SQL Server.
The licensing is based on the core.
Pricing is very reasonable.
The pricing is palatable.
It also has features like the AWR report, which helps analyze resource usage during specific times.
Foglight allows us to monitor multiple database platforms.
The profiler allows us to look at the profiles of the database queries that are being run over time.
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
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
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.
