Oracle Enterprise Manager and Foglight for Databases both compete in the database management space, each with unique strengths. Oracle Enterprise Manager has the upper hand in environments heavily invested in Oracle technologies due to deep integration, while Foglight excels with cross-platform versatility.
Features: Oracle Enterprise Manager offers comprehensive cloud management with self-service applications, sophisticated Oracle application management, and extensive database tuning options like SQL Tuning Advisor and ADDM. It supports both Oracle and non-Oracle databases, emphasizing Oracle technologies. Foglight for Databases provides robust monitoring across multiple database platforms, including Oracle, SQL, MySQL, and others, with real-time activity screens and efficient SQL Performance Investigator tools. It has adaptive baseline monitoring and detailed workload analysis.
Room for Improvement: Oracle Enterprise Manager requires frequent patches, has a complex upgrade process, and users report stability and performance issues in larger deployments. Foglight users face challenges with alert management, root cause analysis efficiency, and integration with other application performance monitoring systems. Creating custom reports in Foglight also presents difficulties.
Ease of Deployment and Customer Service: Oracle Enterprise Manager supports on-premises and hybrid cloud environments and usually requires more manpower during deployment and maintenance. Customer service reviews are mixed, with some dissatisfaction regarding response times. Foglight supports private and public cloud configurations, often requiring integration with third-party solutions but is praised for proactive customer service and a clear licensing model.
Pricing and ROI: Oracle Enterprise Manager is deemed expensive, particularly with optional packs, enhancing ROI through reduced downtime and proactive monitoring, but requiring careful cost management. Foglight, though not the cheapest, has straightforward licensing and is cost-effective across varied environments, providing competitive pricing and good value with flexible licensing for long-term customers.
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.
When contacting My Oracle Support, I encounter first-line support initially, which is inadequate as I require more in-depth support.
I would rate Oracle Enterprise Manager's technical support at an eight.
When trying to connect with non-Oracle products and applications, the connection process is not very straightforward.
We have not faced any challenges or difficulties with it.
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.
Adding AI features for automated replies or helpdesk support would improve Oracle Enterprise Manager.
Currently, it works better and has more stability. It crashes less frequently, which provides a better experience.
Setting up the Oracle Enterprise Manager is challenging as it requires setting up a separate server.
Pricing is very reasonable.
The pricing is palatable.
I would rate the pricing of Oracle Enterprise Manager as very expensive, definitely deserving a 10 out of 10.
In terms of pricing, Oracle Enterprise Manager is on the premium side compared to other monitoring tools.
The licensing is based on the core.
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.
The tool allows us to monitor 24/7, configure dashboards, and quickly check the status of databases that are in critical states.
One of the most valuable features of Oracle Enterprise Manager has been the preventive reporting capability.
The functions and features of Oracle Enterprise Manager that I have found most valuable are its evolution from being problematic in 10g and 11g versions to becoming better and more stable.
Foglight for Databases offers comprehensive monitoring with real-time activity screens and adaptive baselines. It provides a 360-degree overview and efficient UI, requiring no custom scripts, aiding in proactive issue identification and resolution before impacting end users.
Foglight for Databases is a robust tool for monitoring across multiple platforms, including SQL and Oracle. It provides features like the "Morning Coffee" dashboard and SQL Performance Investigator, enabling effective workload analysis and historical investigation. Despite some challenges with sluggish performance on large data volumes and excessive non-critical alerts, it remains a preferred choice for its ability to support proactive management and resource planning. Users appreciate its centralized view of extensive database systems, enabling swift detection and resolution of issues in real-time.
What are the key features?Foglight is extensively implemented in industries managing extensive database systems, handling numerous servers to ensure availability and performance. It assists businesses in resolving blocking and locking deadlocks, crucial for maintaining smooth operations in production and development environments.
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.”
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.