Oracle Enterprise Manager Valuable Features

Muhammad Usman Muzaffar - PeerSpot reviewer
Senior Vice President IT Operations at ZTBL

It is a good tool for monitoring databases. It enhances the overall visibility within the database.

View full review »
SM
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 »
Ahmad Hida - PeerSpot reviewer
Application and BI manager at Ithmaar-solutions

The most valuable features of the solution are its stability and the performance of the databases from Oracle.

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.
765,234 professionals have used our research since 2012.
JL
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.

View full review »
AK
Manager Oracle Apps DBA /OCI Architect at Wipro Limited

Oracle Enterprise Manager triggers critical alerts. 

View full review »
CB
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
Database Administrator at ZTBL

Oracle Enterprise Manager helps to control servers.Mostly its load and performance and its disks utilization

View full review »
AM
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 »
Nicola Fusco - PeerSpot reviewer
Manager, IT Security at SCM GROUP S.p.A.

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 »
Robin Saikat Chatterjee - PeerSpot reviewer
Head of Oracle Cloud Infrastructure Solutioning Technology and Architeture at Tata Consultancy Services

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 »
Ashish Gaire - PeerSpot reviewer
Sr. Sun Solaris Field Support Consultant at World Distribution Nepal Pvt.Ltd

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

View full review »
SR
Member of management at Cyprobes

The solution is easy to use and has good performance.

View full review »
Andrea Trespidi - PeerSpot reviewer
Storage & Backup Engineer at a tech vendor with 10,001+ employees

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.

View full review »
SK
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 »
it_user521865 - PeerSpot reviewer
Senior Database Administrator at Robert Half

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 »
MajedAlzahrani - PeerSpot reviewer
Oracle database lead at Ministry of Energy

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 »
Oussama Bourguiga - PeerSpot reviewer
DevOps engineer at Esprit

Oracle Enterprise Manager is a scalable solution.

View full review »
Louis Mtambo - PeerSpot reviewer
Application Support Officer at FINCA MALAWI

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

View full review »
Brian Imambaks - PeerSpot reviewer
Founder at Technovate

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 »
it_user436020 - PeerSpot reviewer
Lead Oracle Database Administrator at a insurance company with 10,001+ employees

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 »
it_user521820 - PeerSpot reviewer
Sr. Software Engineer at a energy/utilities company with 10,001+ employees

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
ICT officer at BASABA

It is a good solution. It is the best database management system.

View full review »
PT
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 »
it_user522195 - PeerSpot reviewer
Senior Oracle DBA at a retailer with 10,001+ employees

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_user522081 - PeerSpot reviewer
Senior Application Manager at HDR inc

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 »
PatrickKuria - PeerSpot reviewer
Enterprise Systems Engineer at Sybyl

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 »
Akin Temel - PeerSpot reviewer
Database Manager at Gantek

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. 

View full review »
Kopano  Ramaphoi - PeerSpot reviewer
Consultant at SmartCloud

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 »
it_user83460 - PeerSpot reviewer
Consultant at a tech services company with 51-200 employees
Monitoring, EM Jobs and IP/BIP Reports View full review »
TK
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
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 »
it_user436173 - PeerSpot reviewer
Senior Oracle Database Administrator at a pharma/biotech company with 5,001-10,000 employees

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 »
it_user515583 - PeerSpot reviewer
Senior Database Analyst at a financial services firm with 1,001-5,000 employees

Database Management, SQL Tuning, Performance Management, SQL Monitoring, Performance Tuning Pack, SQL Diagnostic Pack, ADDM, AWR, and real time SQL monitoring.

View full review »
it_user448812 - PeerSpot reviewer
Senior Managing Consultant at a tech consulting company with 501-1,000 employees

The monitoring and alerting capabilities and ability for corrective actions in incidents provide the most value.

View full review »
it_user517617 - PeerSpot reviewer
Director at a financial services firm with 1,001-5,000 employees

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 »
it_user500253 - PeerSpot reviewer
Lead Architect (Oracle Ebusiness Suite, OBIEE, BI Apps, EPM) at a tech services company with 501-1,000 employees

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.


View full review »
it_user521964 - PeerSpot reviewer
Division Officer at a government with 10,001+ employees

The GUI interface for monitoring and managing databases is the most valuable feature.

View full review »
it_user436206 - PeerSpot reviewer
Oracle Applications DBA/UNIX SA at a agriculture with 1,001-5,000 employees

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 »
it_user450624 - PeerSpot reviewer
Manager of Oracle Technology/DevOpsManager at a retailer with 1,001-5,000 employees

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 »
it_user521991 - PeerSpot reviewer
Oracle DB A

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 »
it_user521883 - PeerSpot reviewer
DB Manager at Secure-24

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 »
it_user515430 - PeerSpot reviewer
Works at a energy/utilities company with 10,001+ employees
  • 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.
View full review »
it_user515322 - PeerSpot reviewer
Works at a tech company with 10,001+ employees

Valuable features include SQLrun and the performance page.

View full review »
it_user82836 - PeerSpot reviewer
Engineer at a tech services company with 51-200 employees

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 »
it_user100257 - PeerSpot reviewer
Oracle Consultant & DBA - Cloud Support Engineer at Amazon Web Services
Consolidate information and access to my databases into a single portal. View full review »
SS
System Administrator & Oracle DBA at a government with 10,001+ employees

The most valuable features are security and speed.

View full review »
it_user522018 - PeerSpot reviewer
DBA at a tech services company with 10,001+ employees

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 »
it_user522063 - PeerSpot reviewer
DBA at a manufacturing company with 10,001+ employees

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 »
it_user522126 - PeerSpot reviewer
Oracle DBA at Group Dynamite Inc

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 »
it_user522168 - PeerSpot reviewer
DBA at a aerospace/defense firm with 10,001+ employees

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 »
it_user429384 - PeerSpot reviewer
Enterprise Architect at a tech services company with 501-1,000 employees

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 »
it_user448638 - PeerSpot reviewer
Business Owner at Techno Consulting

I have mainly used it for management, monitoring and tuning for Oracle databases.

View full review »
it_user436200 - PeerSpot reviewer
Database Admin at a insurance company with 10,001+ employees

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 »
it_user431829 - PeerSpot reviewer
Professional Services Manager at a tech services company with 501-1,000 employees

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 »
it_user86742 - PeerSpot reviewer
Database Senior Manager with 501-1,000 employees
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
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.

View full review »
it_user44463 - PeerSpot reviewer
Lead Database Administrator

The speed at which I can drill down to isolate issues.

View full review »
it_user240024 - PeerSpot reviewer
Managing Director at a tech services company with 10,001+ employees

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 »
it_user522171 - PeerSpot reviewer
Senior Manager For Application And Database Architecture at Wesco Aircraft

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 »
it_user522135 - PeerSpot reviewer
IT Specialist at a government with 1,001-5,000 employees

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 »
it_user521859 - PeerSpot reviewer
Enterprise Architect at Revenu QuŽbec

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

View full review »
JQ
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 »
it_user522240 - PeerSpot reviewer
Healthcare Operations Supervisor – Optum Health San Francisco at a healthcare company with 10,001+ employees

I can run the database, run queries, run reports, see the whole picture, and analyze the data.

View full review »
it_user522186 - PeerSpot reviewer
Database Engineer at a comms service provider with 10,001+ employees

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 »
it_user488784 - PeerSpot reviewer
System Architect at a consumer goods company with 10,001+ employees

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 »
it_user90537 - PeerSpot reviewer
Database Manager at a energy/utilities company with 501-1,000 employees
Reporting and tuning View full review »
KA
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. 

View full review »
CA
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_user522192 - PeerSpot reviewer
Oracle Database Architect at a computer software company with 501-1,000 employees

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.

View full review »
it_user521577 - PeerSpot reviewer
Sr. IT Professional and Database Expert at a manufacturing company with 10,001+ employees

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 »
it_user436107 - PeerSpot reviewer
Sr DBA at a energy/utilities company with 1,001-5,000 employees

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 »
it_user101664 - PeerSpot reviewer
Lead DBA at a tech company with 501-1,000 employees
Real-time performance monitoring View full review »
RH
Head of Application Support & Infrastructure at a financial services firm with 201-500 employees

I like that it's stable.

View full review »
AF
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 »
it_user522051 - PeerSpot reviewer
Is Business Analyst at Emerge

The ability to capture data and then processing it based on what we need to pull for analysis.

View full review »
it_user522087 - PeerSpot reviewer
Lead Database Administrator at Accertify inc

It monitors our database environment, which is very critical for our environment.

View full review »
it_user521619 - PeerSpot reviewer
Oracle/SQL Server Database Administrator at Chevron

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 »
it_user522069 - PeerSpot reviewer
DB A at a university with 1,001-5,000 employees

Performance diagnostics. That is the best.

View full review »
it_user521547 - PeerSpot reviewer
Senior System Analyst at a aerospace/defense firm with 1,001-5,000 employees

Monitoring of the database is the most valuable feature, because we want to know what's going on there.

View full review »
it_user97683 - PeerSpot reviewer
Database Senior Manager at a financial services firm with 1,001-5,000 employees
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 »
it_user82773 - PeerSpot reviewer
Database Expert at a energy/utilities company with 10,001+ employees
Real-time monitoring we can quickly find the session or queries that are causing issues. View full review »
OO
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
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.

View full review »
it_user432612 - PeerSpot reviewer
Sr Application/Oracle Programmer at a university with 1,001-5,000 employees

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 »
it_user515415 - PeerSpot reviewer
Sr Oracle DBA at a retailer with 10,001+ employees

One of the valuable features is performance drill down.

View full review »
it_user486507 - PeerSpot reviewer
Software Engineer, Banking Officer at a financial services firm with 10,001+ employees

The best features are the usability and the interface.

View full review »
it_user521925 - PeerSpot reviewer
DBA at a tech services company with 10,001+ employees

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 »
it_user521988 - PeerSpot reviewer
Database Analyst at a financial services firm with 1,001-5,000 employees

The automating diagnostic monitor (ADM) is the most valuable feature.

View full review »
it_user522066 - PeerSpot reviewer
Lead App Adviser at a tech services company with 10,001+ employees

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 »
it_user80244 - PeerSpot reviewer
Head of Data Analytics at a manufacturing company with 51-200 employees
The performance console is a must. View full review »
it_user1017 - PeerSpot reviewer
eCommerce Expert at a computer software company with 501-1,000 employees
• 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_user522057 - PeerSpot reviewer
DBA at a pharma/biotech company with 1,001-5,000 employees

It's user friendly.

View full review »
it_user522108 - PeerSpot reviewer
Senior Client Partner at a tech services company with 10,001+ employees

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 »
it_user521916 - PeerSpot reviewer
IT Manager at a tech vendor with 1,001-5,000 employees

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 »
it_user436146 - PeerSpot reviewer
President at a tech consulting company with 51-200 employees

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 »
it_user101799 - PeerSpot reviewer
Sr. Oracle, MySQL and Teradata DBA at a tech vendor with 51-200 employees
Monitoring and tuning of Oracle databases. View full review »
it_user521574 - PeerSpot reviewer
Bhavinee Patel at Apple

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

View full review »
it_user436065 - PeerSpot reviewer
IT Director at a tech services company with 51-200 employees

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 »
it_user436104 - PeerSpot reviewer
Data Modeler at a financial services firm with 1,001-5,000 employees

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 »
it_user100476 - PeerSpot reviewer
MySQL DBA at a tech vendor with 501-1,000 employees
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 »
it_user79794 - PeerSpot reviewer
Database Expert with 51-200 employees
Real Time monitoring i.e SQL Monitoring and the ADDM View full review »
reviewer960693 - PeerSpot reviewer
Software Developer at a tech services company with 10,001+ employees

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 »
it_user744699 - PeerSpot reviewer
Database Administrator Manager at a international affairs institute with 11-50 employees
  • Remote administration
  • Corrective actions
  • Custom reports
  • Oracle Secure Backup integration
  • Exadata/SuperCluster plugin
View full review »
it_user435981 - PeerSpot reviewer
Programmer/Analyst at Lidestri Foods

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 »
it_user522156 - PeerSpot reviewer
Analyst at a tech services company with 1,001-5,000 employees

Everything you do; you can see the whole picture. You can everything in one place. That's very good, very convenient.

View full review »
it_user103347 - PeerSpot reviewer
Senior Oracle DBA at a financial services firm with 501-1,000 employees
Performance tuning, segment and memory advisor View full review »
it_user521871 - PeerSpot reviewer
Lead / Senior Systems Analyst at a tech vendor with 1,001-5,000 employees

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 »
it_user436440 - PeerSpot reviewer
Oracle Specialist at a tech company with 10,001+ employees

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 »
it_user89634 - PeerSpot reviewer
Database Manager at a manufacturing company with 1,001-5,000 employees
Performance tuning, Alerting, SQL Tuning, Database Reporting View full review »
it_user522258 - PeerSpot reviewer
Engineer at a tech services company with 10,001+ employees

The look and feel I think. Fast and compatible. It's easy to customize.

View full review »
it_user521940 - PeerSpot reviewer
DBA with 10,001+ employees

Helps us to monitor the databases and avoid any downtime.

View full review »
it_user101802 - PeerSpot reviewer
Oracle DBA at a financial services firm with 501-1,000 employees
Overall monitoring of Oracle databases and operating systems. Real time performance tuning of SQL queries. View full review »
it_user92496 - PeerSpot reviewer
Database Manager at a recruiting/HR firm with 51-200 employees
I really like how Statspack has evolved into AWR, ADDM and ASH reports, fully automated out of the box. View full review »
it_user3876 - PeerSpot reviewer
Database Manager at a tech company with 51-200 employees
• 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.
765,234 professionals have used our research since 2012.