Try our new research platform with insights from 80,000+ expert users
PeerSpot user
Database Engineer
Real User
The documentation and knowledge bases are extensive,so often you can resolve your own issues

How has it helped my organization?

The big win here is alerting - if configured sensibly (don't use the out of the box settings) with some planning this can be a real asset - alerts can also be sent to your problem management system and steered towards exactly the right group of people using target labels such as "line of business" or "department".

What is most valuable?

Alerting, patching, general monitoring. Each host to be monitored requires and agent to be installed and configured - this process is mature and works well.

What needs improvement?

It's much more than a monitoring package - sometimes when scratching beneath the surface you end up with issues . Such as agents requiring security, scan listeners moving about after fail overs, some patching processes failing - these are relatively rare though and considering the breadth of the product I would not consider this an issue.

What do I think about the stability of the solution?

No system works well.

Buyer's Guide
Oracle Enterprise Manager Cloud Control
May 2025
Learn what your peers think about Oracle Enterprise Manager Cloud Control. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.

What do I think about the scalability of the solution?

IF configured correctly this product is fully scalable.

How are customer service and support?

Customer Service:

8/9 out of 10 - Oracle support is generally very good - sometimes they need nudging / issues need escalating bit the support model is good.

Technical Support:

generally good - the documentation and knowledge bases are extensive - so often you can resolve your own issues.

Which solution did I use previously and why did I switch?

No.

How was the initial setup?

You need to install oracle middleware and an oracle repository DB back end

Install scripts are good however with proper planning/sizing there shouldn't be any issues.

What about the implementation team?

In-house

What was our ROI?

OEM is invaluable in many ways, other products can replace bits of it - but the product should be used as a single point from which to view as much of your enterprise as possible.

What's my experience with pricing, setup cost, and licensing?

You will probably already be an Oracle user and so will have an existing license agreement. Add-on's can be pricey though.

Which other solutions did I evaluate?

Nothing else was considered for Oracle database monitoring.

What other advice do I have?

Its one of those products that you can, and should customise to your own requirements. Don't expect a one off install then leave it to take care of itself. Proper procedures will greatly assist, and time spent discovering features can be very rewarding. Agent deployment is straight forwards, and the agents are light weight and easily maintainable

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Regional Team Lead - Applications & Systems Integration at a tech services company with 1,001-5,000 employees
Consultant
I was particularly interested in the monitoring and alerting features. The interface could use some work.

What is most valuable?

My interaction with OEM was primarily for governing Oracle 10g/11g databases. I was particularly interested in the monitoring/alerting features, table maintenance automation, performance dash-boarding, and Active Data Guard management.

How has it helped my organization?

I used this with clients, but not internally. For those with larger footprints, but with an inexperienced staff, it really helped to cushion the issues brought on by skill gaps. It also provided greater visibility of database performance for administrators. This helped prompt decisions around capacity and availability.

What needs improvement?

The interface for Data Guard could use some work. We had challenges with switchover/failover testing.

For how long have I used the solution?

I have used this solution for three years.

What do I think about the stability of the solution?

We have not had any stability problems.

What do I think about the scalability of the solution?

We have not had any scalability problems. My largest installation had approximately 16 databases. We did not challenge the server's existing compute resources.

How are customer service and technical support?

Technical support from Oracle was not required during my implementation.

Which solution did I use previously and why did I switch?

There was no previous solution. The solutions deployed had a fair Oracle footprint, so it was determined that OEM would be the best fit.

How was the initial setup?

The initial setup was straightforward. OEM's GUI is pretty comprehensive and user-friendly. The documentation is very clear in terms of prerequisites and steps to be executed.

What's my experience with pricing, setup cost, and licensing?

The base product, including DB Control, is free. However, additional Ops Center management packs, e.g., Tuning, Lifecycle Management, must be licensed in accordance with Oracle's guidelines. It's very easy to get confused about this. We recommended a comprehensive review of the licensing documentation, or a sit-down meeting with the vendor, prior to installation.

Which other solutions did I evaluate?

We did not look at any alternatives.

What other advice do I have?

Depending on the size of the Oracle footprint that you need to monitor, it's a good idea perhaps to pursue an Oracle Licensing Agreement with the vendor. This will allow you to implement management packs more easily. I would recommend this for larger environments of 25 or more databases.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Oracle Enterprise Manager Cloud Control
May 2025
Learn what your peers think about Oracle Enterprise Manager Cloud Control. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
PeerSpot user
Database Team Lead at a financial services firm with 1,001-5,000 employees
Vendor
Real-time SQL, performance monitoring and SQL Tuning Advisor are very effective to find problems and to resolve them.

What is most valuable?

Real-time SQL, performance monitoring and SQL Tuning Advisor are the features that I use the most. These features are very effective to find problems and to resolve them.

Besides these, setting alert mechanism, getting AWR reports and monitoring the Exadata hardware are the most useful features.

Also, adding clients remotely from the Oracle Cloud Control 12c screen makes this version different from the earlier ones.

What needs improvement?

There are still doubts as of how to use this tool for administration issues such as storage or replication operations. DBAs still prefer to administer databases by manual commands. They rather use this tool to monitor databases and alert mechanisms.

To be more specific, most DBAs (that I've met) prefer to use “Sqlplus”, “putty”, “secureCRT” command line tools or “Toad” tool to manage replication or to manage storage(tablespace, control file etc) instead of using EM Cloud Control.

They do not feel relaxed using EM Cloud Control for those subjects. Oracle may emphasize on those subject on the trainings. Or Oracle Support Engineers can motivate the customers about using those features if they are really stable.

For how long have I used the solution?

I have used this solution for more than four years. Before this, I was using earlier versions of the product, i.e, Oracle Enterprise Manager 11g.

What do I think about the stability of the solution?

With the earlier release, we did encounter stability issues. But, now I use version 12.1.0.4.0. and I do not see any stability problems.

Which solution did I use previously and why did I switch?

I have used the earlier version (i.e version 11g) and also, I have used dbconsole (i.e., the Oracle Enterprise Manager Console dedicated to one server). I switched to this version so as to administer my database and the Exadata hardware from one point.

How was the initial setup?

The setup is not complex. Everyone can do it by using its official documents as well as the tutorials that can be found from the web easily.

What's my experience with pricing, setup cost, and licensing?

If you plan to use OEM Cloud Control 12c for a corporate company, it will be better to get the Diagnostics and Tuning Pack or the Management license based on your needs. This tool will be your most important assistant. But for smaller goals, you can use the base OEM functions for free (http://docs.oracle.com/cd/E246...).

Which other solutions did I evaluate?

If you use Oracle, you do not have many options. This product is the best for a DBA. But, if you have license limitations, then you can use it with the base functions or you can use Oracle Enterprise Manager Console (dbconsole).

What other advice do I have?

Implementing this version is so much easier than the earlier ones. You do not need to install agents into the client one by one. You can install the agent from one point (i.e., from the OEM Cloud Control 12c screen). You just need some firewall actions before installing the agents. Implementation is easy, there is no need for a lot of engineering.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Head of Oracle Development at a tech services company with 5,001-10,000 employees
Real User
It helps to monitor many of the different targets and resources.

What is most valuable?

Oracle Enterprise Manager Cloud Control (EM CC) is the best product for monitoring many of the Oracle databases and other Oracle applications such as Siebel, E-Business Suite, WebLogic.

The product has a common user-friendly interface which provides simple maintenance and administration tasks.

How has it helped my organization?

The Oracle Enterprise Manager (EM) helps to monitor many of the different targets and resources.

It is a flexible system for metrics and for the notifications that inform the DBAs and system administrators, before the occurrance of a problem.

What needs improvement?

I think EM should be able to monitor new products from different vendors. I would like to have unified monitoring interface to monitor other software and hardware, for example: AIX operating systems, including IBM-specific features (HMC, LPAR parameters), disk and tape storages, some optical switches and other enterprise production hardware.

For how long have I used the solution?

I have been using this solution for about a year.

What do I think about the stability of the solution?

We did encounter some stability issues but many of them were fixed.

What do I think about the scalability of the solution?

I did not encounter any scalability issues.

How are customer service and technical support?

I would give the technical support a rating of about 7/10. This estimation is true for the Oracle support in general.

Which solution did I use previously and why did I switch?

I used some open-source products, like Zabbix. I moved from the open-source products over to Oracle EM because it has many embedded metrics.

How was the initial setup?

This product has a simple installation. All of the steps are described in depth in the Oracle documentation and I didn't have any problems with it.

What's my experience with pricing, setup cost, and licensing?

From what I know, Oracle EM CC requires the Oracle Diagnostics and Tuning Pack license if you want to monitor Oracle databases.

Which other solutions did I evaluate?

Oracle EM is a unique product, i.e., if you need to monitor many of the Oracle products in detail.

What other advice do I have?

My opinion is that this product must be used in companies that have many Oracle databases.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user524421 - PeerSpot reviewer
Oracle DBA with 10,001+ employees
Real User
Users see the real-time behavior of the database and can diagnose where an issue may exist.

What is most valuable?

The performance feature is most valuable to me. It allows the user to see the real-time behavior of the database and diagnose where an issue may exist. It also has advisor functions that give recommendations on what to do to fix any problems with performance of the database.

How has it helped my organization?

The product has made it possible to reduce the size of the performance team and still be able to correctly monitor all the databases and fix issues quickly, resulting in fewer downtimes.

What needs improvement?

This product is a web-based tool and sometimes has conflicts with some web browsers. This can be improved to make it more compatible with most of the popular web browsers.

For how long have I used the solution?

I have used it for two years.

What do I think about the stability of the solution?

I encountered no issues with stability of the product.

What do I think about the scalability of the solution?

As the number of databases increased, the tool got a bit slower. Its response time increased with larger number of databases.

How are customer service and technical support?

Oracle provides excellent technical support for the product.

Which solution did I use previously and why did I switch?

I did not previously use a different product.

How was the initial setup?

Initial set up seems a bit complex from the beginning. Because it’s a web-based tool, it requires proper configuration to function properly with the browser.

What's my experience with pricing, setup cost, and licensing?

For all the real-time benefits you get from using the product, I can say it is worth the price for licensing.

Which other solutions did I evaluate?

Before choosing this product, I did not get the chance to evaluate other options.

What other advice do I have?

Take time to study how to use the product. It is very helpful, if it is put to maximum use.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
PeerSpot user
Database Administrator at a recruiting/HR firm
Vendor
RMAN backup jobs can be created and all the database instances can be monitored from one place.

What is most valuable?

There are lot of features in this product that I like. Among them are that RMAN backup jobs can be created, and that all the database instances can be monitored from one place. Tablespaces can be monitored and data files can be added when required. Also, it's easy to generate ADDM, ASK, and AWR reports.

How has it helped my organization?

In my organization, the RMAN backup jobs are configured through this product. Also, we have test, prod, UAT, and QA servers. All these database instances are easy to monitor from this product.

What needs improvement?

I think the help file should include more in-depth documents for the user to collaborate with all aspects of the product even if they haven't had product training.

For how long have I used the solution?

I have been using it for three years, and before that I used Oracle Enterprise Manager Grid Control.

What was my experience with deployment of the solution?

Once, after migrating the server, we had an issue of not being able to start it. We wanted to restore the OEM12C to another server, but the process was so complicated and the testing was not successful. Later, we were able to continue with the previous one.

What do I think about the stability of the solution?

We have had no stability issues.

What do I think about the scalability of the solution?

There have been no issues scaling it for our needs.

How are customer service and technical support?

The level of customer service and technical support are good. I understand the product is highly technical, so sometimes issues need more investigative time.

Which solution did I use previously and why did I switch?

I used Oracle Enterprise Manager Grid Control and switched because this is the updated version and it's in the cloud. There are a lot of benefits behind using the cloud, and we wanted to take advantage of using the cloud through this product.

How was the initial setup?

The initial setup was straightforward since we followed the setup guide, which was easy to follow. However, in some cases we faced some issues, but they were easy to figured out.

What about the implementation team?

My company implemented it through a vendor team before I joined. Since the product was new and very few people had advanced knowledge of the product at that time, they preferred to implement it through the vendor team.

What other advice do I have?

The product is good for monitoring all databases, but in some cases it's not easy to maintain. For example, if the server crashes and we need to restore the monitoring system, it's very complex. This product is very good for monitoring purposes as well as for cloud databases.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user431790 - PeerSpot reviewer
it_user431790Database Administrator at a recruiting/HR firm
Vendor

It should be ASH-- Active session history instead of ASK. Sorry for the printing mistake and confusion. Email notifications is another important feature of Oracle Enterprise Manager 12C cloud control.

it_user419211 - PeerSpot reviewer
Associate at a tech services company with 51-200 employees
Consultant
The two most valuable features we've found are the email notifications and the live, real-time monitoring. It would be nice if there was a way to seamlessly clone the configurations.

What is most valuable?

In our experience, the two most valuable features we've found are the email notifications and the live, real-time monitoring. They really allow us to stay on top of things.

How has it helped my organization?

As contractors, we manage a whole bunch of different environments and servers. EM Cloud Control gives me a good way to look at everything in one snapshot and to stay on top of daily monitoring.

Another big thing is that it helps with the down time. Instead of having to wait for a user to report an issue, I get an email notification, and most times I can fix it before anybody even knows that something went down.

What needs improvement?

They're moving everything off of our currents servers into the cloud. It would be nice if there was a way to seamlessly clone the configurations onto Cloud Control and then into the new environment so that I don't have to reconfigure everything.

What was my experience with deployment of the solution?

We've had no issues with deployment.

What do I think about the stability of the solution?

The stability is pretty good. Sometimes it runs slowly, but that may be due to our network. Generally, though, it's good. The downside is that there is a lot of configuration overhead to get it working the way you want.

What do I think about the scalability of the solution?

We only have one instance of it running. We're not so big that scalability is a concern.

How are customer service and technical support?

We've had a few issues, opened CRs, and had no trouble getting them resolved. So technical support has been good.

Which solution did I use previously and why did I switch?

We were using Grid Control and we switched as we didn't have a place to have just one dashboard with everything on it.

How was the initial setup?

The initial setup is not hard; it's just time-consuming.

What other advice do I have?

What it does, it does well, but it's so complex. There are a lot of quirks to get it to do what you want it to do. Do blackouts before you take anything down, because if you don't, you will get a gigantic shit storm.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user431790 - PeerSpot reviewer
it_user431790Database Administrator at a recruiting/HR firm
Vendor

good points! email notifications are minimizing DBA's stress.

it_user8583 - PeerSpot reviewer
Database Expert with 501-1,000 employees
Vendor
EM12c - A Step Backwards?

Enterprise Manager Cloud Control 12c is mostly a better product than the 10g version we were using before. But I am getting really frustrated with the Explain Plan functionality.

A big part of my job is performance tuning and monitoring running SQL. And to do that you need a clear, quick, stable view of the query plan, along with all pertinent information, such as the total cost of the plan. in EM10g, we had that.

EM12c, though, is a huge step backwards.

Specifically:

1. When using the "Real Time: 15 sec refresh" function, every refresh shows the "Graphical" version of the Plan. You have to then switch to the "Tabular" version, if that's what you prefer.

2. The "Tabular" view in EM10g included a summary top line showing the total cost, total IO cost, total CPU cost, etc. This is no longer available in EM12c.

3. Previously, each node of the Plan was (if appropriate) a link back to the object referenced by that step of the plan. So if the optimizer had chosen an index lookup, you could click on the index name in the plan and go to the index definition page. Superb for deciding whether the optimizer had chosen a"good" or "bad" index. Now, in EM12c, there's no drill-down functionality in the Plan. One needs to open a separate tool to analyze table or index structures alongside the EM12c Plan page. This is a terrible step backwards.

4. Not a feature in 10g or 12c, but it would be nice to be able to set one's preferred view of the plan to "Graphical" or "Tabular" and for that view to remain, no matter what refresh setting is being used in View Data.

Unless I'm missing something obvious -- and please tell me if I am! -- Oracle have really messed up here. I'm surprised no-one else has spotted these as issues. Am I alone? Or have I really missed something in the configuration?

The ability to easily view and compare SQL Plans in EM10g was great. It should have been better in EM12c. But Oracle has made it worse. It's virtually unusable now. I have to go outside EM and use TOAD to get decent Plans now. Oracle - please re-instate the original functionality.

UPDATE: Oracle have confirmed that I'm not being dim and missing something obvious. The functionality that was there in OEM 10g and 11g has been 'designed away'! I've asked MOS to raise an enhancement request to put it back in.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Oracle Enterprise Manager Cloud Control Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Product Categories
Cloud Management
Buyer's Guide
Download our free Oracle Enterprise Manager Cloud Control Report and get advice and tips from experienced pros sharing their opinions.