Oracle Enterprise Manager Review

It is easy for the novice DBA to drill down and find problems that might otherwise be difficult to find.

Valuable Features

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.

Improvements to My Organization

It has helped developers and novice DBAs drill down and find the cause for problems. There are two pieces. One, it allows people to pinpoint issues easily, and then drill down and get more details of the issue. Previously, this used to be a skillset in the hands of a very few people, but now virtually anybody can do it. Even if they can't fix the actual problem, they could filter down a lot of the issues, and get only the relevant information, which is helping us.

Room for Improvement

I probably would like to see better SQL tuning advisors that are built into the product. When you know the issue, rather than just pinpoint it, if it could also give you a solution that might work, I think that would help the product.

There are a few things on the wish list. We would hope that it makes some predictions of what we could fix and also the resources for printing that it takes. In some cases, it is not available when we need it the most.

Stability Issues

It is mostly stable, but we have found some issues when we are having resource contention or CPU issues. It is not easy to bring up the product because it is a bit of a resource hog. Sometimes when you need it the most, that is when you find it missing, but those are rare and far between.

Scalability Issues

It is a very scalable product. No complaints there. We use it for hundreds of databases and it grows.

Customer Service and Technical Support

On a scale of 1 to 10, I would probably give Oracle tech support somewhere between a 6 and a 7. Often, when you know what the issue is, there is a lot of collecting data for root cause which we might have provided just the previous day. We find ramp up is a bit of a waste of time before we can actually get a solution.

Previous Solutions

We were covered by the Oracle enterprise license agreement and it made more sense for us to go with this product as opposed to looking for another one. They have had it for a very long time.

Initial Setup

It is a very straightforward setup and also we had help from Oracle as part of our enterprise license agreement with my company. They helped set it up and it has been working pretty well.

Other Solutions Considered

It was an easy choice. The Oracle Enterprise Manager is pretty well known and I don't think anything else, an external product, matches or comes even close.

Other Advice

Look at the reputation and the size of the company. These products are often very expensive. It is better to go with someone who has been around for a long time and who would continue to be in business, as opposed to flavor-of-the-month products.

When I am looking at a vendor such as Oracle, the most important criteria that I am looking for from them are market reputation, the scale of the company, and the stability.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 visitor found this review helpful
Add a Comment
Sign Up with Email