Try our new research platform with insights from 80,000+ expert users
it_user44463 - PeerSpot reviewer
Lead Database Administrator
Vendor
As a troubleshooter, I was able to quickly resolve memory issues with this product

What is most valuable?

The speed at which I can drill down to isolate issues.

How has it helped my organization?

  • As a troubleshooter, I was able to quickly resolve memory issues.
  • Finding the top 10 longest running queries helped to control query performance issues. 

What needs improvement?

Metrics settings could be improved to be more intuitive.

Installation process could be easier. 

There could be better configuration documentation.

For how long have I used the solution?

10 years.

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

What was my experience with deployment of the solution?

No issues.

What do I think about the stability of the solution?

Stability is good. No issues.

What do I think about the scalability of the solution?

I do not have a need for this product's scalability.

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

No.

How was the initial setup?

It was complex. The installation document was tough to understand.

What about the implementation team?

I installed the tool myself.

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

Get this tool.

Which other solutions did I evaluate?

Yes, DBArtisan.

What other advice do I have?

I am very happy with this tool.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Team Lead, Database Administration at a financial services firm with 10,001+ employees
Real User
Wait-events can be viewed and investigated in real-time, making resolution easier
Pros and Cons
  • "Some of the most valuable features are its real-time performance view/dashboard, metric history, real-time monitoring and alerts, as well as quick access to Oracle's tuning and diagnostic options."
  • "I feel more dashboards can be added, especially those useful to higher levels of IT management."

What is most valuable?

Some of the most valuable features are its real-time performance view/dashboard, metric history, real-time monitoring and alerts, as well as quick access to Oracle's tuning and diagnostic options.

These are valuable because it makes it much easier to investigate periods in the past (good or bad) as metrics for a period are stored in the repository. Real-time resolution of issues is made easier as wait-events can be viewed and investigated in real-time. SQL queries can also be viewed and investigated in real-time and recommendations are available if the diagnostic and tuning packs are licensed (Oracle databases).

In my experience it seems the best tool for monitoring Oracle products, ranging from software to hardware like the engineered systems (e.g. Exadata).

How has it helped my organization?

In my team, we have display screens dedicated to displaying the real-time wait-events of our most critical databases. Every team member can look up and tell the average health of the critical Oracle databases at a glance. If something unusual is going on, it is immediately apparent on the display.

In addition, Oracle Enterprise Manager completely and adequately handles our hardware and software alerts which are sent out by email as soon as set thresholds have been exceeded.

What needs improvement?

I feel more dashboards can be added, especially those useful to higher levels of IT management.

I feel it would be great to have improved support for other database types like MySQL and Microsoft SQL Server.

I also think additional software like the JAgent for monitoring GoldenGate installations should be integrated into Oracle Enterprise Manager itself, and not require additional installation and configuration.

For how long have I used the solution?

About four years.

What do I think about the stability of the solution?

Generally, it is pretty stable. Occasionally, one may run into errors that may be tricky to resolve without in-depth knowledge of the product or the help of Oracle Support.

What do I think about the scalability of the solution?

No, I haven't had any issues with scalability so far.

How are customer service and technical support?

On a scale of one to 10, eight.

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

We previously used Dell Spotlight, but needed more in-depth administration and monitoring capabilities, as well as a web interface.

How was the initial setup?

Initial setup was pretty straightforward. Most administrators with some experience in installing Oracle applications and databases shouldn't have a problem setting it up, as long as they follow the installation guide.

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

As with all Oracle products, care should be taken when using any features to ensure that they do not activate licensed features that have not been paid for. Oracle Enterprise Manager allows one to do so many things easily, but it is up to the administrator to be sure of the licensing implications.

Which other solutions did I evaluate?

Dell Spotlight was the only other option we looked into before settling on this product.

What other advice do I have?

Oracle Enterprise Manager is great for monitoring and administering Oracle hardware and software. However, administrators should ensure that their actions are limited to free and licensed features only, otherwise there may be trouble at the next Oracle license review.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Oracle Enterprise Manager
March 2025
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
845,485 professionals have used our research since 2012.
it_user101664 - PeerSpot reviewer
Lead DBA at a tech company with 501-1,000 employees
Vendor
I can easily visualize bottlenecks in database performance tuning with historical graph trends

What is most valuable?

Real-time performance monitoring

How has it helped my organization?

Can easily visualize bottlenecks in database performance tuning with historical graph trends; where as before it would be based upon manually tuning using scripts which are text based. Ability to get email alerts for systems in trouble; where as it would have been manual steps to obtain health-checks on all database servers.

What needs improvement?

Stability and bugs in the product. There seem to be too many.

For how long have I used the solution?

3 years

What was my experience with deployment of the solution?

Many problems which were fixed with patches.

What do I think about the stability of the solution?

Initially yes, but after patching it was stable; but with applying the latest version 12.1.0.3, we seem to be unstable again.

What do I think about the scalability of the solution?

No

How are customer service and technical support?

Customer Service: Appalling, raised issues with support and that take ages to respond.Technical Support: Appalling; they take far too long to understand the issue, they just simply appear to read scripts; if our problem is not on the script; then they struggle to think.

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

No

How was the initial setup?

It was a complex installation, in that we have 2 servers as opposed to a single all in one solution; but it was nothing we could not manage.

What about the implementation team?

In-house

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

Initial set up was approx. 5 days’ worth of DBA’s effort

Which other solutions did I evaluate?

No

What other advice do I have?

Be prepared for a lot of heartache before it beds in. Get the latest patches for the project, and read up on most common bugs issues before implementation;
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522063 - PeerSpot reviewer
DBA at a manufacturing company with 10,001+ employees
Real User
We use it for day-to-day performance monitoring.

What is most valuable?

The performance monitoring is the most valuable feature. We use it for a lot of performance monitoring. It's a good tool. It works well. We use it on a day-to-day basis.

How has it helped my organization?

It reduces our downtime; increases our performance. We get to know of any issues coming up before even the users complain about it. We know what's going on in the system using Enterprise Manager.

What needs improvement?

If it had more drill-down facilities, that would be great. We found that sometimes, if you drill down into certain views, it's slow and it's very costly, so we avoid doing those kinds of things. They need some improvements in that area; to optimize those drill-downs.

What do I think about the stability of the solution?

It's pretty stable. Once in a while, we do have agents which hang and we have to reboot the agents. But overall, it's pretty stable.

What do I think about the scalability of the solution?

We use it enterprise-wide, so it's pretty scalable. We haven't had any issues.

How is customer service and technical support?

Usually my team is not the one that looks after technical support, but I'm not sure. We don't support the tool; we just use it.

Which other solutions did I evaluate?

Before choosing this product, I did not evaluate other options.

What other advice do I have?

Go for it. It's very good. It's pretty user-friendly. You just go with the flow. Just click on what you need to see and take it from there. We don't see any specialized training required to use it.

We integrate it with Oracle E-Business Suite and it works fine.

I'm very happy with it.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521577 - PeerSpot reviewer
Sr. IT Professional and Database Expert at a manufacturing company with 10,001+ employees
Real User
You can check your SQL executions and how the SQLs are progressing in terms of any blocks or contention in the database.

What is most valuable?

You can monitor your database thoroughly. Some valuable features of this product are checking your SQL executions and how the SQLs are progressing in terms of any blocks or contention in the database. In other words, you can monitor the entire progress of your database per millisecond.

How has it helped my organization?

It benefits our organization by identifying the problem immediately and rectifying it. So, the user doesn't have to bear any sort of impact.

What needs improvement?

Some of the features that need improvement are increased monitoring at the operating system and storage levels, without having a plugin. At the Oracle level, improvements can be done by providing minute details in regards to SQLs.

What do I think about the stability of the solution?

The product is stable 99.9% of the time, but there are a few issues that need to be improved. I have noted that these issues are generally updated in a later version of the product, as and when it is released.

What do I think about the scalability of the solution?

Oracle does provide some plugins. However, if these can be provided with the Oracle Enterprise Manager software itself, there is a scope for scalability. In addition, increased monitoring at the storage level and the OS level can really help.

How are customer service and technical support?

The technical support is not always 100% up to the mark or sometimes not as we expect it to be.

At times, they (the customer support team) take more time to respond or we don't get the desired response/solution from their end and then we have to keep tracking them.

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

We have always been using this product.

How was the initial setup?

The setup is simple and not complex. I find that it has improved with later versions that are being released.

The setup process used to take much longer than it does now and I hope that this will be enhanced in the future.

Which other solutions did I evaluate?

We have not evaluated any other product besides Oracle, as it suits our product best.

What other advice do I have?

Stability and responsiveness are the two major factors while choosing a product. Right now, response time is the most critical aspect for our organization and that is what we need.

If you database scalability is more or if your infrastructure is as big as the product we have, Oracle is the only solution out there. There are other competitors, but they are all NoSQL database tools. Thus, Oracle stands out.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521619 - PeerSpot reviewer
Oracle/SQL Server Database Administrator at Chevron
Real User
My company chose it because we can see that it's going to be more aligned with the cloud.

What is most valuable?

We haven't fully utilized it yet on a day-to-day basis, but we will put more into it. We do see patching is going to be a big improvement. Day to day, I think we are at 20 percent for now, but that number will increase.

What needs improvement?

Support definitely can be improved; documentation and support. The documentation is convoluted, very confusing.

For how long have I used the solution?

I have been using it for four years.

What do I think about the stability of the solution?

It's stable, so far.

What do I think about the scalability of the solution?

So far, it's okay; it scales.

How is customer service and technical support?

The support is not good for this product. The enterprise system that I have is kind of complex. Support is very basic; they don't have someone who really is savvy.

How was the initial setup?

Initial setup is okay. It's 50/50.

What other advice do I have?

My company choose to use this product because I can see that it's going to be more aligned with the technology, with the cloud. It's more robust, and we can see it's going to be an essential product for IT.

When I’m deciding whether to work with a vendor such as Oracle, I look for kind of a mix that includes reliability and strategic too: How does it fit into the enterprise system?

I recommend Oracle Enterprise Manager.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522171 - PeerSpot reviewer
Senior Manager For Application And Database Architecture at Wesco Aircraft
Vendor
It provides visibility for Oracle and non-Oracle hardware, software, and middleware.

What is most valuable?

Oracle Enterprise Manager provides a single pane of control that gives you the visibility to see all Oracle products, plus the non-Oracle products; hardware, software, middleware. It covers it all.

How has it helped my organization?

The benefits to my organization are with administration, plus it centralizes your control.

What needs improvement?

There are a lot of plugins. I would like to see more and more plugins for different software. Most of them are third-party software. If Oracle Enterprise Manager could provide a standard web service to interface with any application, that would be ideal.

I don't think anybody can walk on water. Software is buggy and that's the nature of the beast.

What do I think about the stability of the solution?

Stability is excellent now; not so much, before.

What do I think about the scalability of the solution?

Scalability is endless because you can use Oracle technology to expand the back end and also use Oracle technology to expand the front end.

How are customer service and technical support?

Technical support is very helpful. They were efficient. Usually, Oracle support is very good.

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

We previously used vendor-specific monitoring or control systems to administer different type of resources; hardware, software. OEM gives me the ability to expand that by putting everything under one control console.

How was the initial setup?

I was involved in the initial setup, and it was pretty straightforward. Over the years, they have even simplified a lot of processes. Before, you had to install this and that, but now it's just one single installation that does it all.

Which other solutions did I evaluate?

For me, choosing this solution was a no-brainer because we are an Oracle shop. From having all different types of vendors for hardware and software, we are gradually becoming an Oracle shop.

What other advice do I have?

Try to understand what OEM can do for you. Exploit it and its feature set. For example, I can modify the back-end storage through OEM. I don't have to go to my ZS4 console to see how much space I have, how to administer it, or how to allocate storage space to a particular project. I can do that through OEM. That's the power of having a single pane for control.

When I’m looking at a vendor such as Oracle, support is the most important criteria. Over the years, Oracle product has improved the stability, so that the most important thing now is how fast they can provide solutions when I need their help. That's the most important thing.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522168 - PeerSpot reviewer
DBA at a aerospace/defense firm with 10,001+ employees
Real User
What makes it valuable is that we have one single pane that we can access to get all of our information.

Valuable Features

What makes it valuable is that we have one single pane that we can access to get all of our information and be proactive, whether it's Oracle Database, SQL Server, MySQL, or whatever, even host related.

Room for Improvement

Every release, they seem to move the navigation and you have to retrain your entire DBA staff. Maybe the user interface could be more consistent between releases. For every minor and major release, it usually jumps around all over the place.

Use of Solution

We've been using it for quite a while, probably since 11g and a little bit before that; so, for 6, 7 years or more.

Stability Issues

I think it’s stable. Every once in a while, it's kind of buggy, but for what it is, it's pretty good.

Scalability Issues

So far, it has been scalable. I think it's going to meet our needs moving forward.

Customer Service and Technical Support

For the most part, depending on who you get, technical support usually is good. Sometimes, it's hit or miss, but it depends on who you get those first few times.

Initial Setup

For initial setup, you actually have to have some experience. If you don't, it can get a little tricky. I got a lot of gotchas. Even if you read the instruction manuals, the documentation, there are still things that you need to be looking out for.

ROI

I think it provides value for the money. It definitely helps us be proactive in our database administrating. We don't have to spend time reacting to everything. We can find out where the problem is before our customer even realizes they have a problem.

Other Advice

Look into OEM, especially if you have a lot of databases that you want to monitor, or other products. It provides a single pane of information that you can use, and drill down capabilities to find exact problems.

When I select a vendor such as Oracle to work with, I look for them to be reliable, provide value and so on.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2025
Buyer's Guide
Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros sharing their opinions.