Oracle Enterprise Manager Cloud Control Reviews and Pricing

Database Expert with 501-1,000 employees

Aug 13, 2013

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.

PatrickKuria

Enterprise Systems Engineer at Sybyl

Aug 31, 2023

Download

A management platform that provides single dashboard to manage all Oracle deployments

Pros and Cons

"The report feature is very useful."

"The configuration is not straightforward for web continuity. It needs some improvement and the deployment is expensive."

What is our primary use case?

The solution is being used as a monitoring tool.

What is most valuable?

The report feature is very useful.

What needs improvement?

The configuration is not straightforward for web continuity. It needs some improvement and the deployment is expensive.

For how long have I used the solution?

I have experience with Oracle Enterprise Manager Cloud Control.

What do I think about the stability of the solution?

It is a stable product. I rate the stability a nine out of ten.

What do I think about the scalability of the solution?

It is a scalable solution. I rate the scalability a nine out of ten.

How was the initial setup?

The initial setup is okay. For the deployment a step by step documentation needs to be followed.

What about the implementation team?

The deployment can be done in-house.

What was our ROI?

I have seen Return on Investment.

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

One has to pay for the enterprise version.

What other advice do I have?

I recommend using the solution. I rate the overall solution a nine out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Buyer's Guide

Oracle Enterprise Manager Cloud Control

August 2025

Free Report: Oracle Enterprise Manager Cloud Control Reviews and More

Learn what your peers think about Oracle Enterprise Manager Cloud Control. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.

DOWNLOAD NOW

865,295 professionals have used our research since 2012.

Kanaga Manian

Lead Consultant Oracle Apps Dba at a tech vendor with 1,001-5,000 employees

Jan 27, 2024

Download

A monitoring solution that helps also to extract data from databases

Pros and Cons

"The solution helps database tuning through query ID and SQL ID; we can fine-tune skill parameters and gather information to enhance operational analysis and performance."

"Oracle Enterprise Manager Cloud Control needs to improve its GUI."

What is our primary use case?

I use the solution for monitoring purposes. So, by running the agents, we can connect to our client, extract data from the database, and facilitate work component integration within the enterprise.

What is most valuable?

The solution helps database tuning through query ID and SQL ID; we can fine-tune skill parameters and gather information to enhance operational analysis and performance.

What needs improvement?

Oracle Enterprise Manager Cloud Control needs to improve its GUI.

For how long have I used the solution?

I have been using the product for a year.

What do I think about the stability of the solution?

I rate the solution's stability a seven out of ten.

What do I think about the scalability of the solution?

I rate the tool's scalability a seven out of ten.

How was the initial setup?

Oracle Enterprise Manager Cloud Control's deployment was straightforward.

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

The solution's pricing is fine.

What other advice do I have?

I rate the tool a seven out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.