Oracle Enterprise Manager Valuable Features
It is a good tool for monitoring databases. It enhances the overall visibility within the database.
View full review »SM
Suresh_M
Database administrator at SSnC
The job subsystem, monitoring subsystem, alerting, grouping of targets, and reporting features are valuable to us. Sending alerts based on groups is also useful. The product serves the purpose that we are using it for. We are very satisfied.
View full review »The most valuable features of the solution are its stability and the performance of the databases from Oracle.
Buyer's Guide
Oracle Enterprise Manager
March 2024
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,995 professionals have used our research since 2012.
JL
James Lui
Team Lead - Oracle Applications DBA at a energy/utilities company with 1,001-5,000 employees
The 13cR5-PG (Patch Group) 6 updates to the OEM family, strongly integrate Cloud (off-site, hybrid and on-premise) services providing a seamless way to see all of your resources regardless of where they are deployed.
PG6 adds enhancements for EMCLI (Command Line Interface) extensions to allow additional automation and scripting of common OEM tasks (Blackout begin/end, Patch availability monitoring, cloning enhancements.)
The 12c series of Oracle Enterprise Manager products, version 12.1.5.0.x introduced Cloud (both public and private) support for both monitoring, and lifecycle management. This allows individual components, or entire systems to be resident either in-house on conventional hardware/VM's, or ported into virtualized datacenter environments, off-site, whether for fault tolerance and disaster recovery, or simply to reduce the cost of non-Production systems by using a pay-to-play methodology (reducing investment in specific hardware just to support disposable and transitional software systems development?) Consolidated and uniform monitoring of all Oracle-related technologies. Ability to enable centralized control and administration of Oracle products from a single console. Ability to see at a glance, all conditions of all products throughout the enterprise. Version 13c includes hybrid cloud support making transparent the transfer of provisioning systems between Oracle's Cloud and on-premise equipment. All of the cloud systems and in-house systems appear in logical groups according to their common function (Applications, Middleware, Databases, etc.) The configurations are also snapshot-friendly and made comparable to quickly isolate differences between similar systems.
In the Oracle Cloud Infrastructure (OCI) based Oracle Observability and Management OAM (formerly Oracle Management Cloud (OMC)) 1.53.0 you have many subscription-based options, like Log Analytics and Application Performance Management that you can activate quickly, try them on for size, and keep them or decomission them for relatively less cost and time than doing so, on-premises. These features also avail you access to technologies requiring higher horsepower (CPU/RAM/etc.) found in the OCI Exadata-based Virtual Machines (VMs) that may be beyond your current investment level. Newly added features, include Java deployment central administration, logging analytics, 21c and 23c compatibility, and enhancements for the new cloud service extensions.
Continued development of the Cloud Management suite has integrated further dynamic container and vCPU management options to the cost management side of the Integrated Lights-Out features of the cloud service providing better management of your capacity planning, and thus cost mitigation.
AK
Ashish Kothalkar
Manager Oracle Apps DBA /OCI Architect at Wipro Limited
Oracle Enterprise Manager triggers critical alerts.
View full review »CB
Chris Bradham
Senior Technical Director at AEM Corporation
SQL Tuning Advisor, ADDM, Top Activity, ASM Space Manager, Incident Notifications. The ability to identify performance bottlenecks and make an immediate impact can serve as a significant contribution to Database Administers which saves time and resources.
View full review »AH
AbdulHameed
Database Administrator at ZTBL
Oracle Enterprise Manager helps to control servers.Mostly its load and performance and its disks utilization
View full review »AM
Alwyn Musson
IT manager at EDUNET COMPUTING RESOURCES
The dashboards are great for gathering analytic information and seeing where the problems are.
You can look at many databases from one single point of view.
The solution is stable.
It scales very well.
It's easy to set up.
View full review »We use Oracle Enterprise Manager for a lot of services like ERP and PLM. We have different applications that are using the solution.
View full review »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.
View full review »The single-pane and single interface in the centralized system is the most valuable feature. All the enterprise services can be seen from a single pane, whether it be a database, applications, or hardware. We can manage and monitor from a single page.
View full review »SC
Scot-Conrad
Principal Oracle Applications DVA at a tech services company with 501-1,000 employees
It's a useful feature to be able to see the top SQL, the number of executions, the CPU, and the resources that it's using.
Also, being able to utilize that to look at the plans that are being generated for that piece of SQL and then determine how we can change that to increase the performance.
SR
Sharique Rizvi
Member of management at Cyprobes
The solution is easy to use and has good performance.
View full review »SK
SK26
Technical Consultant at a computer software company with 51-200 employees
The most valuable feature of the solution is that it is a very user-friendly tool. I find Oracle Enterprise Manager to be a complete tool because it has options like SQL Scratchpad, Oracle Migration Workbench, etc.
View full review »The most valuable feature is the performance monitoring. This is one single-point dashboard, which presents the health of the database, at a particular point in real time. It helps you see which queries are running, and the top file sessions that are running. That helps you accurately identify what is bogging down the system.
That top session, which is chewing up CPU resources and memory, helps you see if it is doing the right thing, using the right indexes, using the best EXPLAIN PLAN. If everything is all good, maybe that tells you the box’s resources is not enough. However, 90% of the time, there are bad queries, rogue queries; it provides ample opportunities to queue.
Thanks to this tool, it helps us drill down, get to the bottom of the problem really quickly. Quick identification of a problem is key. Once the problem is identified, then you have other tools to figure out how to make this query run fast.
There are nice features like the hash report and AWR codes. At the click of a button, on the fly, you can generate these reports, which tell you exactly at the time of the clicking the health of the database; how well or how bad it is running. That is what the business is looking at from the DB. DB is like a doctor. They want the cure. They want to know what is the problem for the disease. This helps us identify the health of the database in real time, fast.
View full review »The best part is the efficient database performance monitoring and the ability to take actions directly from there. For example, if any issues arise, such as performance slowing down or sessions getting stuck, you no longer need to go to the server and write a script to address them.
View full review »Oracle Enterprise Manager is a scalable solution.
View full review »The most valuable features of Oracle Enterprise Manager are the data guide and online monitoring.
View full review »For us, the most valuable feature is really the ability to monitor. We're using Enterprise Manager to monitor our database infrastructure. Whenever we create a database, we'll apply those templates, and it will monitor. Database will send alerts and create instances that will allow our team to be both reactive and proactive and use some of the warnings that it brings us. We're using it a lot for that -- the ability to do performance tuning, using the OEM, the ability to create different reporting, the ability to be able to get some suggestions from the OEM, in terms of the database performance.
The tool also gives us the ability to create reports for a set of databases, or a set of applications, such that we can create a daily report, weekly report, monthly report, whatever you want, to know about the performance utilization of that group of databases or specific databases.
That's really the key advantage of Enterprise Manager. Although we're using it for Database, the tool has enhancements to provide benefits to an entire IT shop in terms of monitoring and managing the entire IT infrastructure.
View full review »Using this product makes our integration process more easy and seamless. Previously, it used to be hard for a few applications. Now with this product, we can easily define our RES service or sub-service and can have multiple platforms hitting the service.
We have a dedicated security layer and use this as a security layer.
View full review »GR
Gichuru Riria
ICT officer at BASABA
It is a good solution. It is the best database management system.
View full review »PT
Prerak Trivedi
Consultant at a energy/utilities company with 10,001+ employees
Max use was server monitoring and operations of applications. This helps handling of critical situations in a production and support for the customers.
View full review »The most valuable feature is the monitoring because it's very useful for checking and troubleshooting compared with other products, like Nagios for example, that have some interaction with Oracle. Enterprise Manager is good for a DB administrator to troubleshoot and check monitoring.
This is a very good Oracle tool which enables us to incorporate all the databases throughout our environment, set up several rules and even monitor from there. We can perform a lot of operations. If you have small databases you can plug into the OEM, and you can perform any sort of operation with one click of a button. That makes it more convenient and makes life easier than logging into each database separately.
You can set the rules so that every time you have several maintenance activities you don't need to go to each database and do the same work again and again. Instead you can create jobs in the OEM and you can also create groups, like production, development, performance and environment. All these environments you can club together so that you can perform several operations based on environment-specific criteria.
When you need to perform activities like purging and archiving, this can be done easily and you can even do backups which is a tedious activity. If you have the right description monitor, just click on the buttons in the OEM so that you can fire up the backups everyday at a specific time. It can even alert us by email if by any chance the backup fails and you can just log in to a particular mission and check why it failed.
It's a very easy way of maintaining all the databases instead of wasting time on the regular day to day tasks. You can use your time productively, instead of investing time on these mundane tasks. That way it helps us a lot.
View full review »It basically provides a transformation for the company to go into the product line application. It gives better and faster data to the management in order to review the data quickly.
View full review »I like how you can drill down to a problem, like which specific query is causing the most workloads, which user has issued that query, what's taking up the most resources, et cetera.
It's easy to implement as it's made by Oracle for Oracle. Yeah. It's very insightful when it comes to what you can check healthwise on a database.
View full review »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.
It's more effective to use command-line interface than using the GO setup.
One of the great things about that EM is that you are able to connect to Oracle Support. This will make your work easier due to the fact that it will help you identify if your database is to be upgraded or if you are experiencing any issues. It can help you quickly identify issues instead of having to raise them in a service report. It's much more efficient.
There are a number of different user interfaces you can choose from.
The solution is pretty interactive and user-friendly.
View full review »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.
View full review »
Monitoring, EM Jobs and IP/BIP Reports
View full review »
TK
Tebogo Tico Kamati
Systems Analyst at a government with 201-500 employees
I am satisfied with the solution. It enables me to keep a check on my business. It is a good product. We can manage everything in our environment. It is the best solution in the market. I am satisfied with the integrations provided by the product.
View full review »GA
Gokhan Atil
Database Architect, Oracle ACE Director at Bilyoner.com
Oracle Enterprise Manager provides comprehensive monitoring features for all Oracle products. It has an extensible architecture, so it’s possible to add third-party plugins to extend its monitoring abilities. These are valuable features of Oracle Enterprise Manager for all Oracle customers.
On the other hand, I think the most valuable feature of Oracle Enterprise Manager is its management capability for Oracle products. It makes a real difference when comparing it to any other monitoring solution in the market. You can manage your Oracle Databases, Oracle VM, WebLogic, and other products with Oracle Enterprise Manager.
View full review »OEM gives me, as the DBA, a very graphical representation of what's going on with my Oracle footprint, and it's very quick to display to me where I would have issues and where I can correct them. This gives me the capability to see when there are issues happening, which means that I can actually act on the issues pretty quickly before it becomes apparent to the business that there is something going on within the database, that could, for example, have a negative effect on their ability to get a drug out the door.
View full review »Database Management, SQL Tuning, Performance Management, SQL Monitoring, Performance Tuning Pack, SQL Diagnostic Pack, ADDM, AWR, and real time SQL monitoring.
View full review »The monitoring and alerting capabilities and ability for corrective actions in incidents provide the most value.
View full review »I manage a team of Customer Care and Billing Support Administrators. Earlier in our implementation when we were not quite stable we had to request assistance from our DBAs to troubleshoot performance of our databases. We eventually convinced them that it would be to their advantage to provide us with read only access to the graphs and to run AWR reports in OEM so we could troubleshoot ourselves. We actively monitor the databases and can get ahead of any issues. We are also making preparations for using OEM with Oracle Utilities Application Management which will provide application monitoring through OEM.
View full review »The most valuable features are the Metric Extensions & Advanced Threshold management.
Metric Extensions
- Extend Oracle's monitoring capabilities to monitor conditions specific to your IT environment
- Provides a comprehensive view of your environment
- Create metrics on any target type
- Can be defined on any target:
- Hosts
- Databases
- Fusion applications
- BI components…
EM is a one-stop shop used to manage and monitor the entire Oracle E-Business Suite, BI and EPM infrastructure in our company. So, in our BI environment, we wanted to run a script to kill sessions which are running over 60 minutes and wanted to track and tune those sessions. We used Metric Extensions for the same.
Advanced Thresholds allow you to define and manage alert thresholds that are either adaptive (self-adjusting) or time-based (static).
- Adaptive thresholds are thresholds based on statistical calculations from the target's observed behaviour (metrics).
- Time-based static thresholds are user-defined threshold values to be used at different times of the day/week to account for changing target workloads.
We used time-based threshold settings for weekday and weekend load on various environments. This way we could fine tune the alerts for varying loads.
The GUI interface for monitoring and managing databases is the most valuable feature.
View full review »I find it nice that OEM provides a graphical way to manage both our database and E-Business Suite. It's great being able to see that all the information you need is in front of you on the screen. There are links that allow you to kill sessions or to check your performance. With other solutions, you just see numbers go by on a screen.
View full review »In my opinion, without Enterprise Manager no DBA can do their job. There are better tools out there, but they only complement OEM because it may not do the whole job. OEM, though, is very intuitive when it comes to performance tuning, metrics, and monitoring.
View full review »I mostly use the top events, and look at how the execution is happening on the database; and monitoring the cluster level rates. I even look at the execution plan.
I really love this tool because I don't need to type the commands. It's very user friendly, I just click and get the reports and get it done.
View full review »I think the look and feel and the accessibility to the databases, the scale of environment support. Ours is basically like a hosting company and we have a thousand databases and the way you can get to the metrics, quickly figure out the ETA to fix a problem, these are the things that I love.
View full review »- Managing databases via groups
- Running AWR and ADDM reports is simple and quick.
- Performance graphs are good to share with application teams and database users.
Valuable features include SQLrun and the performance page.
View full review »A lot of ingenuity has been put into the monitoring and alerting capabilities. There are many products (including a number of custom scripts I have written over the years) that are capable of sending basic alerts, for example when a file system mount is approaching capacity, but all of those pale in comparison to the myriad functions Enterprise Manager has. For example; taking corrective action to fix a problem before it even becomes a problem; create a trouble ticket, package the necessary log files and automatically submit that ticket; or perform root cause analysis of a number of related incidents, just to name a few.
View full review »
Consolidate information and access to my databases into a single portal.
View full review »
SS
reviewer1447671
System Administrator & Oracle DBA at a government with 10,001+ employees
The most valuable features are security and speed.
View full review »You can get a healthful overview of all your targets in one snapshot in Enterprise Manager. You can see what's up or what's down and then take corrective action. It's a valuable tool for an admin like me.
View full review »The performance monitoring is the most valuable feature. We use it for a lot of performance monitoring. It's a good tool. It works well. We use it on a day-to-day basis.
View full review »The most valuable is when a client calls us to tell us the performance is really bad, I can quickly go on to OEM and see which SQL is causing the problem. I can drill down. I can quickly apply a profile to that SQL. The only drawback that I don't really like about that is they have to restart their job at the gate. The equipment profile doesn't take affect right away. You have to stop it, and you have to restart it. Other than that, it's fantastic. If they're able to stop it, you tell them to stop it. If not, you have to wait until tomorrow, where you'll see a better performance.
It's very quick, it's very easy to use. Considering the old AWR reports, which are still out there, you can get an AWR report at that particular time in OEM. OEM does data guard; you can set it up. They had a session at a conference I went to. They had the old DBA, which is like me, and the young DBA, which they used Justin Bieber. They were using the OEM, and the old DBA was still using their scripts. They were showing that the young DBA, which had no experience in Oracle whatsoever, was able to troubleshoot the problem much quicker than the old DBA who was running all his old scripts to figure out what the problem was. That's one of the things I really like about it.
Another thing is that you're able to see all your databases. Right now, we have 13 databases, so I can quickly monitor any of the 13 databases.
View full review »What makes it valuable is that we have one single pane that we can access to get all of our information and be proactive, whether it's Oracle Database, SQL Server, MySQL, or whatever, even host related.
View full review »I think the neatest, most valuable feature of Enterprise Manager (OEM) is that single pane of glass for the whole stack, that it gives me as an admin the ability to look all the way up from my storage all the way up to the application tier.
View full review »I have mainly used it for management, monitoring and tuning for Oracle databases.
View full review »The most valuable feature is the way it shows me, on top in one screen, right there, my availability options. Then if I have to drill down the performance, it shows me what's running, rather than me going in and doing my own scripts. It provides AWR reports, active session reports, and things like that.
View full review »Over and above the monitoring, alerting and incident framework, all of which are excellent, I would say the Lifecycle Management Pack is of most value to us.
View full review »
The tight integration with Oracle ASH, AWR and ADDM is invaluable. Management of Oracle Appliances with support for system health monitoring and performance views for all hardware and software components.
View full review »
AS
reviewer1480089
Manager Database at a real estate/law firm with 1,001-5,000 employees
It is the best monitoring tool for Oracle databases.
You have full visibility with the tool, it is a complete solution.
The software is simple to use.
The speed at which I can drill down to isolate issues.
View full review »It is a comprehensive, end-to-end solution for managing database consolidation, something that has been missing and difficult to do. The Database Consolidation Workbench provides a risk-free and accurate approach to consolidation by eliminating guess work and human errors. Most of the errors that lead to severe issues in production environments are due to poor sizing of the configuration and so-called “educated guesses”. The Workbench provides a flexible approach for various customer scenarios: every environment is unique and several scenarios are possible.
View full review »Oracle Enterprise Manager provides a single pane of control that gives you the visibility to see all Oracle products, plus the non-Oracle products; hardware, software, middleware. It covers it all.
View full review »The most valuable feature is the monitoring of all of the different types of targets in our infrastructure, including not only the Oracle Database components, but the SQL Server components also, in the host.
View full review »The most valuable feature is the automation of the alerting. We can be proactive when we use that program instead of being called in the middle of the night because something’s wrong. You get the alert and the warning before. You can customize every threshold to meet your needs, and have different settings for different database groups.
View full review »FK
Farooq Khalid
Manager DBA at a healthcare company with 1,001-5,000 employees
Database performance monitoring, dashboards, databases management and Dataguard setup and monitoring are the features that I like the most.
BI Publisher is another cool feature to generate customized reports.
JQ
Jessie Quinn
Senior Enterprise Database Engineer at Genesis Financial Solutions, Inc.
I have found the singular GUI feature very helpful. Fewer DBA resources can be allocated with Toad licenses.
View full review »I can run the database, run queries, run reports, see the whole picture, and analyze the data.
View full review »The most valuable feature is that it is very easy for the novice DBA to drill down and find problems that might otherwise be difficult to find.
View full review »Both OS and Hardware Management, Network Boot, Server Pools, and Live migration of LDOMs over Server Pool are Ops Center's most valuable features to me.
View full review »
Reporting and tuning
View full review »
KA
Khalil AbdulrahmanAlasbahi
Commercial Manager at Natco Information technology
The most valuable feature is high availability.
The features that we are using the most are for partitioning, Armonk, and encryption.
CA
ChukwuemekaAduba
Team Lead, Database Administration at a financial services firm with 10,001+ employees
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.
These are valuable because it makes it much easier to investigate periods in the past (good or bad) as metrics for a period are stored in the repository. Real-time resolution of issues is made easier as wait-events can be viewed and investigated in real-time. SQL queries can also be viewed and investigated in real-time and recommendations are available if the diagnostic and tuning packs are licensed (Oracle databases).
In my experience it seems the best tool for monitoring Oracle products, ranging from software to hardware like the engineered systems (e.g. Exadata).
View full review »It's a standardized GUI tool, which is very good and pluggable with automatic connection to an Oracle database, in comparison with any other GUI tools available in the market. Other than that, if you see if you want to share the backups, or if you want to do any monitoring stuff, to customize your monitoring, and if you want to do the blackout. If you are doing any amendments, you can do a blackout.
If you want to monitor the regular site without doing any scripting or anything, you just need to plug in both databases, and then it's easy to maintain. It's one tool to maintain all the databases in one place without doing much customization, and it's easy to manage.
You can monitor your database thoroughly. Some valuable features of this product are checking your SQL executions and how the SQLs are progressing in terms of any blocks or contention in the database. In other words, you can monitor the entire progress of your database per millisecond.
View full review »I like the performance tuning features, particularly since it gives me a good glimpse of what has been happening. We maintain the data for 31 days, so I can graphically go back and see what exactly happened during that time. I can drill down to the user level or the SQL level and see what was happening at any point in time. That's a pretty good feature, and because it's more graphical, I don't have to analyze a whole bunch of rows.
View full review »
Real-time performance monitoring
View full review »
RH
reviewer1526349
Head of Application Support & Infrastructure at a financial services firm with 201-500 employees
I like that it's stable.
View full review »AF
reviewer1428951
Oracle Database Administrator Senior Team leader at a financial services firm with 10,001+ employees
The product gives us as much control as we can have by providing a complete picture of the whole set of Oracle products. We can monitor all of them.
View full review »The ability to capture data and then processing it based on what we need to pull for analysis.
View full review »It monitors our database environment, which is very critical for our environment.
View full review »We haven't fully utilized it yet on a day-to-day basis, but we will put more into it. We do see patching is going to be a big improvement. Day to day, I think we are at 20 percent for now, but that number will increase.
View full review »Performance diagnostics. That is the best.
View full review »Monitoring of the database is the most valuable feature, because we want to know what's going on there.
View full review »
Monitoring and the ability to quickly drill down, see and identify issues. Also provisionning is an interesting option as long as it works.
View full review »
Real-time monitoring we can quickly find the session or queries that are causing issues.
View full review »
OO
reviewer1213497
DBA Team Lead at a tech services company with 51-200 employees
We use Oracle Enterprise Manager as a tool to monitor Oracle products. It's a monitoring tool that shows the performance of your Oracle database or many other products.
View full review »VB
reviewer1383255
Senior Project Manager - IT Services at a tech services company with 10,001+ employees
It's the most reliable database available on the market.
The tried and tested services that Oracle provides is second to none.
The solution offers excellent support.
The product is very mature. There are a lot of new upstarts, however, this technology has a long history of quality. While other options may not have many use cases available, Oracle certainly does. They have a wide variety of success stories users can look to.
As a DBA contractor, I like the ability to be able to group my hosts/targets and set up different configurations to monitor based on the needs of my clients.
View full review »One of the valuable features is performance drill down.
View full review »The best features are the usability and the interface.
View full review »It provides a graphical interface and easy management. It's not very cumbersome. The new versions of Oracle, 12c and 13c, have user-friendly graphical interfaces, compared to older versions, where it was very cluttered. You could not figure out where to go at all.
View full review »The automating diagnostic monitor (ADM) is the most valuable feature.
View full review »The most valuable feature is its ability to integrate directly into S Space and move data, run business rules, run calculation scripts, and things like that.
View full review »
The performance console is a must.
View full review »
• Enterprise Manager 12c comes with an out-of-box self-service application that lets end-users deploy a wide range of these services.
End users can choose to manage and monitor all applications along with databases and platforms/OS, all in an on-demand fashion. For each request, they can specify the amount of underlying resources (CPU, memory, etc.) that they require for each component.
• Enterprise Manager automatically provisions the requested service and the appropriate resources. The self-service application also lets users define policies to scale out or scale back resources based on schedule or performance metrics.
For example, one can set a policy to elastically scale out a web server if the processor load on existing web servers exceeds a certain threshold value.
• It allows management of sophisticated Oracle applications, like Oracle E-Business, Siebel, and PeopleSoft, aiding in many administrative activities of these apps, like real user monitoring of any web application.• Enterprise Manager 12c has the ability to define contractual Service Level Agreements (SLAs) that govern the contract between the application owner and the provider of the Cloud. Administrators, as well as users, can also define management policies that automatically adjust the service resources, to ensure that SLAs are met.• Enterprise Manager enables the application for the end-user via a self-service interface, both in graphical (GUI) .
View full review »
It's user friendly.
View full review »The most valuable feature is that it is web-based. That helps us to get access from any location without being dependent on your personal laptop. You can access it from any laptop, any iPad or even iPhone; kind of everywhere.
View full review »I think what I really like in this product is that DBAs and my management development team don’t have to sit and manually write queries.
It has a graphical interface, which makes it handy for you to monitor the databases and that is the most useful feature.
View full review »Enterprise Manager comes with a suite of products that includes agents for setup. This makes it easier to monitor databases as well as servers and SANs.
View full review »
Monitoring and tuning of Oracle databases.
View full review »
The most valuable feature is the user-friendly GUI. With OEM, we can see the monitoring tools for the host or database.
View full review »AG
Alessandro Guimarães
Gerente da Unidade de Negocio Oracle at a tech services company with 11-50 employees
The product has powerful features for diagnosis of database issues, complemented with tuning capabilities for most of the issues found.
With ASH Analytics, ADDM, Real-Time SQL Monitoring, SQL Tuning Advisor, we can measure SLAs, detect performance hotspots, perform deep diagnostics into specific tiers, tune applications, and remediate.
I think the fact that I can manage all of our infrastructure, all the hardware and software, from one place which makes it very useful.
View full review »From my experience, I'd say that the most valuable feature is the ability to manage all the databases, hardware, and middleware from one pane of glass.
View full review »
Query tuning, historical graphs, real time statistics on query usage, easy to find blocking or locking queries, easy to kill queries, easy to add new datafiles to tablespaces about to run out of space, easy to explore table structure
View full review »
Real Time monitoring i.e SQL Monitoring and the ADDM
View full review »
The masking features are good, and many new options and features are available in OEM for masking when compared to other tools.
View full review »- Remote administration
- Corrective actions
- Custom reports
- Oracle Secure Backup integration
- Exadata/SuperCluster plugin
The most valuable feature of OEM is that it goes hand-in-hand with our EDI. Essentially, it allows us to operate the SOA Suite solution on a management level.
View full review »Everything you do; you can see the whole picture. You can everything in one place. That's very good, very convenient.
View full review »
Performance tuning, segment and memory advisor
View full review »
I think it's mainly to do a health check of the system and the application and how the performance is doing, so that we can determine any tuning and tweaking that we need to do; it's helpful.
View full review »I like the reports of Enterprise Manager, as you have a lot of targets. You can create generic reports based on some metrics of those targets. It allows me to have some sort of place to check all my targets.
View full review »
Performance tuning, Alerting, SQL Tuning, Database Reporting
View full review »
The look and feel I think. Fast and compatible. It's easy to customize.
View full review »Helps us to monitor the databases and avoid any downtime.
View full review »
Overall monitoring of Oracle databases and operating systems. Real time performance tuning of SQL queries.
View full review »
I really like how Statspack has evolved into AWR, ADDM and ASH reports, fully automated out of the box.
View full review »
• Provides a platform for tuning multiple databases and scheduling of multiple tasks.
• Monitors database health and performs regular monitoring.
• Used to administer multiple networks and services from multiple locations.
• The Oracle environment, including database servers and application servers can be administered
• Very useful for oracle database administrators. Because DBAs are required to create new user, manage database backups, adding tablespace and data files. Oracle Enterprise Manager offers database administration functionality that helps simplifies the routine tasks of database administrators.
• The graphical interface of Oracle Enterprise Manager provides ease of use to database administrators for managing routine tasks including scheduling of database backup using RMAN.
View full review »
Buyer's Guide
Oracle Enterprise Manager
March 2024
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,995 professionals have used our research since 2012.