Oracle Enterprise Manager Reviews

We have 200+ databases and monitoring that number of databases without using a enterprise tool would involve a tremendous amount of manual work. Furthermore, early notification about databases and operating system alerts helps our DBA team in fixing the issue before there is any major impact on the business.

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.

Middleware (weblogic) has some bugs and crashes occur which should be fixed to make OEM more productive.

This

I have been using OEM for 6+ years

We were using custom build application to monitor the systems but this product provides more functionality and GUI interface.

We have an enterprise Corporate License so cost is not an issue.

We checked Quest software (Spotlight and Toad) however we found OEM to be more productive.

I feel that this a 5 star product because of how easy it is to configure and the vast features that are available.

We use OEM for managing Production, Test and Development environments. It provides a centralized location for proactively administering all database components with the ability to do much more.

SQL Tuning allows massive performance gains behind the scenes in order to more easily troubleshoot the most complex SQL statements. The use of SQL Profiles and creating SQL Baselines, makes improving SQL performance a less time consuming exercise. We've developed a number of monthly metrics we use to show our customer performance and any potential bottlenecks. In addition, we have set up a number of alerts for quickly addressing potential issues.

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.

Patching. It's extremely difficult to determine what requires patching and the process to patch each component is slightly different. In desperate need of a single patch or a simplified process at a minimum. OEM 13c is out and we have it installed. There seems to be some potential bugs associated with implementing third party certificates and the Tuning Advisor so just something to consider before upgrading. 

One new issue came up recently. We upgraded to 12.2 and went with a container/pdb model for each database. After doing so, some of the functionality gets a little tricky with OEM. For some things you need to be in the PDB to work and for other things you need to be in the cdb$root. You can create SQL Profiles through OEM but dropping them through OEM has become a point in futility. Instead, we are doing more manual SQL Tuning Advisor functional through sqlplus which works well.

More than ten years

OEM is a very stable product.

Scalability is not an issue with OEM. It can support a number of targets and target types without sacrificing performance.

We used cron jobs and custom scripts for some of the capability. However, many of those scripts are no longer necessary.

The initial setup was not too painful with 12.1.0.3 as there's good documentation on it. Earlier versions presented some challenges and sometimes required opening a SR to cut through some of the confusion.

In-house

The initial setup was probably a couple of hours of installation time. Besides applying the quarterly patches which takes 2 - 4 hours (we have two Cloud Control environments) another "cost" is hardware resources on a VM. There are a few bugs with the software which require opening SRs with Oracle Support which contribute to the day-to-day cost. Perhaps 8 hours per month is spent dealing with support, just as a rough guess. I would highly recommend the Tuning and Diagnostic Packs for OEM to greatly aid performance tuning with come with additional licensing fees.

We also have Foglight and AppDynamics in house. Foglight will be going away and from my perspective, it doesn't offer any real value over what Cloud Control can provide. AppDynamics offers some nice capabilities in terms of drill down and identifying bottlenecks. I would say it's better about determining the root cause of a problem especially if the root cause is with the application code. However, if the problem is on the database side, Cloud Control will provide through the Advisors ways of fixing the problem which AppDynamics can not do.

The product is very powerful and should be used to automate more key DBA type tasks. Performance tuning bad SQL becomes extremely simplified as long as you leverage the out of box capabilities and you have purchased the Tuning and Diagnostic Pack. Those are a must have to really take advantage of the capabilities.

The main usage is for monitoring performance, a major part of the software is you can define some virtualization for RAM utilization. You can set up something and then you will start getting alerts which you can do some optimizations from the information.

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.

In my experience, the monitoring could be improved. 

If the solution had an auditing feature, I would not look into other software, for example, Imperva or IBM Guardium. These other solutions have an audit feature and monitoring together, this one is strictly monitoring only. Oracle does have a separate product for auditing, which is very expensive.

I have been using the solution for seven years.

It is a very stable product.

We have five administrators that are using the solution, as it is only for administrators.

We have access to the support but the product is really easy to use, we have not needed any help.

The setup was easy, we encountered no problems and it took us only three hours.

We did the implementation ourselves.

The solution is inexpensive to purchase.

I have evaluated Imperva and IBM Guardium. 

I am going to continue to use this product in the future.

I rate Oracle Enterprise Manager a nine out of ten.

Enterprise Manager is a single window plane of glass which allows one to look into every aspect of the systems deployed in an organization. We use it to mange our internal infrastructure, including Oracle Exadata, Oracle Exalytics, Oracle VMs, ERP solutions (such as Oracle Applications and Fusion Middleware, like SOA and AIA), and Oracle Linux servers.

This solution allows us to quickly drill down when there are issues. It helps us monitor solutions both in-house and at our customer premises. We use it extensively for performance tuning testing, monitoring, and configuration.It is also the only tool that can monitr all apects of Exadata , Exalogic and other Oracle engineered systems.

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.

The product is pretty comprehensive, but quite resource hungry. This might be due to the majority of the application seemingly being written in Java. 

Also, better mobile access would be useful.

More than ten years.

There were some issues with the software due to its resource requirements. Be careful to follow the recommended sizing guidelines.

No issues. It is very scalable. Ther are also comprehensive documents for both HA setup and DR setup. One caution is that for DR setup additional licensing is required.

We have not faced any major issues with the product. Auto deployment may be difficult in certain customer environments due to the firwall port issues but in those cases manula deployment of agents is an acceptable workaround. We originally had some timezone related issues due to the fact that my home timezone changed from Asia/Calcutta to Asia /Kolkata but this is no longer an issue

Oracle Enterprise Manager is the only solution which can monitor and drill down into the inner workings of engineered systems, like Exadata and Exalytics. Thus, we had to use this system when we deployed those systems. Being system integrators we work with a wide variety of tools however this tool has very wide support across all of oracles hardware and software.

Setup can be complex depending on the options required. There is a simple express install and a much more elaborate enterprise class setup, which is also possible.

Our in-house team has the capability to implement this (with customers).

This solution was the only one which allows us to monitor all our solutions from one interface. However, the optional packs are expensive, hence your mileage may vary. Please take advice before choosing what exactly to purchase. Remember that the base configuration is free to monitor any Oracle product.

Evaluate your requirements carefully. Elaborate DR and HA setup of OEM can become expensive. 

Be careful to only enable the packs for which you have a license as this is an issue we see time and again. I.e., customers who do not understand the licensing model have not turned off access to packs that they are not licensed for, then get into legal issues for it later.

None of the other options out there have the breadth and depth of this solution. This is the only solution which can drill down to the cell level of an Exadata system. Finally, it has modules available for almost every Oracle product available.

If you are an Oracle shop, or even an Oracle SI, then familiarity with Oracle one stop management solution is an imperative. Everything ties into this solution, so it has become a de facto standard for Oracle-based software given that the base is free to use with Oracle products. There is no downside to deploying this solution in your data center.

Our primary use is for monitoring and management of Oracle products. We are running several Oracle products in our environment.

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.

We would like to have a single dashboard for monitoring and controlling all of our products. This would add value, for us, because as it is now, we have to go to different screens to check different products.

We have been using Oracle Enterprise Manager for about seven years, since 2013.

The Oracle Enterprise Manager is pretty stable and we haven't had any issues.

We have not had to contact technical support for this product because we haven't had any issues. However, if we need to then there is a support portal available.

This product is easy to install and we can complete the deployment in a day, including the agent.

We are satisfied with the pricing.

Overall, I am satisfied with this product. It assists us in finding issues through monitoring services.

I would rate this solution a seven out of ten.

We primarily use the solution for a database.

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.

The solution is considered expensive.

We've been using Oracle for the past five or six years. Some of our customers are on the solution.

The solution is quite stable. There aren't bugs or glitches. It's reliable. It doesn't crash.

The solution is scalable. If a company needs to increase usage, it can do so rather easily.

As we deal with many clients, the sizes of the companies vary. I'm not sure how many users each company would have on one solution. Whether they need 100 or 1,000 users, we'll design the system to meet their needs.

Oracle does provide very good technical support. They have company support models available. If you are a license holder, you can raise your ticket in the Oracle site and get support. It's my understanding that our clients are happy with the level of support available to them.

We use a variety of solutions, according to our client's needs, as we are service providers.

The solution can be both complex and straightforward to implement. If you area laptop user, it's very simple. However, when you need to configure it as a production server, then it's a complex.

Typically, it takes about one to five hours to deploy the product. It's not too long.

If you are only using a developer edition, it will take a maximum of 30 minutes to one hour to deploy. If you need to set up your entire production, then it will take at least a couple of days due to the fact that there are a lot of activities that need to be done.

One active professional can handle an Oracle setup. You don't need too many people to implement it.

We have our own in-house team that can handle deployments for our clients.

The solution is quite expensive. It's not the cheapest on the market. Companies will have to pay a fair bit for it. The pricing is core and processor-based. The overall cost largely depends on how many nodes your company needs to deploy.

We're working with the latest version of the solution.

We're on the service industry side of the business. Whatever our clients need we work to accommodate. Whether they prefer an Oracle server or a Microsoft option, we'll work with them to meet their needs. We don't exclusively deal with Oracle. We would never push our clients to use specific technologies. We just suggest options and highlight the features that best apply to their use cases. Then, we simply follow their wishes and deliver on their expectations.

I'd rate the solution nine out of ten overall. They're very competitive in the market and very good as a product overall. Our clients are happy with it. If the pricing was a bit lower I might give them a perfect ten out of ten.

The primary use case of this solution is used in our HSA Group for backup and recovery.

The most valuable feature is high availability.

The features that we are using the most are for partitioning, Armonk, and encryption. 

RMAN tools need improvement.

There are some doubts about the Oracle policy on price quotes. I have a good relationship with the customers and If I start dealing with them, and get them a discount, then that discount is available to all of the Oracle partners. I prefer the way it works with other companies, like HP, where any discount that I negotiate on behalf of a customer will be available only to me.

This solution is stable, and it's reliable.

This solution is scalable.

Technical support responds quickly. Our customers are satisfied with the availability of technical support.

The initial setup is straightforward. I have been a DBA for ten years now and I have been working with Oracle for twenty-five years.

The pricing is very high.

This solution is the best! It's perfect!

I would rate this solution a ten out of ten.

For masking purposes, and for case studies with the other existing masking tools existing in the market.

It has a very good user interface, and the controls are user-friendly. Many useful options are available.

The masking features are good, and many new options and features are available in OEM for masking when compared to other tools.

With regards to masking still, some options could be added like running in simulation mode, creation of audit file option, file summary, file after masking.