Oracle Enterprise Manager Cloud Control Review

Quickly generates advice on how to improve a query's performance

What is our primary use case?

The use case was the monitoring of the database, which included consumption of resources such as CPU, memory, processes, and I/O.

How has it helped my organization?

One of the clearest examples is the agility of discovering processes/sessions that are burdening the database environment. With this agility, the DBA can more quickly verify this type of problem, in addition to checking locked sessions and not having to do several searches in views and tables of the data dictionary. The tool already does this for you in an agile way.

We had a case where a particular DML command could not perform the required update command on a table, and in this case we saw, within a few minutes, that we had another session doing an exclusive lock on the table. It was caused by an index rebuild command without the "online" option, that marked it to be rotated daily.

What is most valuable?

I believe that one of the most valuable resources this tool has is the ability to check offending processes, which are burdening the hardware resources, and to generate advice quickly that can improve a query's performance.

Another feature is the Resource Manager, where we can manage the consumption of resources of certain queries, separately in resource groups. Depending on the characteristics of the query, queries can be placed in groups that consume less database and hardware resources. 

There are others features as well, such as AWS and ASH report which, in Enterprise Manager, are generated in a more agile way, and with a more friendly interface, helping to detect abnormalities in the database.

What needs improvement?

One of the things that can be improved is the quality of results generated by BI Publisher. They are somewhat confusing when it comes to analysis.

Another point is in the installation of the product. The installation steps are very complex and the documentation for them is very generic and does not make very clear the correct steps from the installation to the addition of the host and database.

Another point that can be improved is the agent instability in the monitored hosts, because sometimes an agent has to be resynchronized to recapture the information.

For how long have I used the solution?

More than five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email