Try our new research platform with insights from 80,000+ expert users
it_user521916 - PeerSpot reviewer
IT Manager at a tech vendor with 1,001-5,000 employees
Real User
The graphical interface makes it handy to monitor the databases. Because of stability issues, we didn't roll it out into production.

What is most valuable?

I think what I really like in this product is that DBAs and my management development team don’t have to sit and manually write queries.

It has a graphical interface, which makes it handy for you to monitor the databases and that is the most useful feature.

How has it helped my organization?

You can manage many databases at the same time.

You don't have to write ad-hoc queries. Initially, my DBAs used to write scripts which were manual. So, running the scripts, writing them and trying to figure out what we want to monitor was a very difficult process. With OEM, you have all of this in the inbuilt interface, which really helped them in adding new databases in the main that we must monitor.

As the number of databases increased, it was fast for us to start monitoring them as well.

What needs improvement?

One of the big problems we had was using Data Guard along with OEM; it just didn’t work (Data Guard is a local higher level solution). Every time we did a takeover, it would stop working, so that was the biggest challenge we had. I think that this has been probably fixed in Oracle Enterprise Manager Cloud Control 13c.

We had issues in terms of stability. Some of the functionalities, which we were looking for, were not available. It's not that it wasn't working, but it wasn't able to meet all our requirements.

What do I think about the stability of the solution?

Stability, as far as it was in a test environment, we did find a few issues. This was in Oracle Database 11g and it would just hang our systems. Thus, we didn't let it go to production.

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

How are customer service and support?

We have Oracle Advanced Customer Support in our company. Using it was easy. It's just that product had a few issues in certain scenarios.

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

Oracle recommended it to us: "Everybody is using it out there, so use it!"

How was the initial setup?

It was straightforward. We had to install a server on the database side and GUI on the client side; it was quite straightforward.

What other advice do I have?

Based on our experience, if you are looking for a certain type of requirement, it would work.

The main requirement for us was stability since we run machine-critical applications.

Resiliency is really the main requirement from our side, even beyond scalability.

We run a company that provides services for banks and financial institutions, and resiliency is the most important factor, especially for a product like OEM. Security is equally important but for OEM, we don't really expose anything, so it's fine. It's more of a monitoring interface.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user436146 - PeerSpot reviewer
President at a tech consulting company with 51-200 employees
Consultant
The agents for setup makes it easier to monitor databases as well as servers and SANs. Using, setting up, and maintaining the agents can be tedious.

Valuable Features:

Enterprise Manager comes with a suite of products that includes agents for setup. This makes it easier to monitor databases as well as servers and SANs.

Improvements to My Organization:

It's given us the ability to monitor multiple aspects of the organization. Also, the ability to monitor different versions of Oracle and different platforms has been helpful for our customers.

Room for Improvement:

Using, setting up, and maintaining the agents can be tedious and even almost a full-time job. Once it's done, it works pretty well. It's just setting them up that could use some improvements.

Deployment Issues:

We haven't had any issues with the deployment other than setting up the agents.

Stability Issues:

I've had problems with its reliability and speed. Sometimes even giving it a large amounts of software and hardware to run on, it can still be sluggish and fail to respond as quickly as you would think.

Scalability Issues:

It does seem to scale. Even when we throw thousands of objects at it, the scalability still seems to be there.

Initial Setup:

The newer versions are much simpler and they have a better look and feel, and once you get the agents taken care of, it goes a lot quicker.

Implementation Team:

We implemented it ourselves.

Other Advice:

If you are going to be database-heavy, and that is what you are going to be monitoring the most, then Enterprise Manager might be your best bet. If not, there are other options out there to look at to see which pieces you need to monitor. Do we need to monitor applications, servers, and networks? Figure out which part you're going to need for that.

Disclosure: My company has a business relationship with this vendor other than being a customer: We're partners.
PeerSpot user
Buyer's Guide
Oracle Enterprise Manager
May 2025
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
851,604 professionals have used our research since 2012.
it_user432612 - PeerSpot reviewer
Sr Application/Oracle Programmer at a university with 1,001-5,000 employees
Vendor
As a DBA contractor, I like the ability to be able to group my hosts/targets and set up different configurations to monitor based on the needs of my clients.

What is most valuable?

As a DBA contractor, I like the ability to be able to group my hosts/targets and set up different configurations to monitor based on the needs of my clients.

How has it helped my organization?

It has made my job easier in that I can put my focus on certain elements at the whim of my client.

What needs improvement?

The one area was the process of setting up targets and hosts as it seems rather lengthy and repetitive. There should be a way to merge some of the steps together.

For how long have I used the solution?

As a DBA contractor, I have been using this solution/configuration since 2013. I started with the upgrade from 11 to 12.

What was my experience with deployment of the solution?

I have had no issues deploying it.

What do I think about the stability of the solution?

There have been no issues with the stability.

What do I think about the scalability of the solution?

I have no issues scaling it as needed.

How are customer service and technical support?

Customer Service:

Customer service has been consistently excellent.

Technical Support:

Technical support has been consistently excellent.

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

My client has always been Oracle based.

How was the initial setup?

With the proper available documentation the setup, although lengthy, was straightforward for the most part.

What about the implementation team?

Implementation was done in-house. My advice, based on the upgrade that we performed, is to create a "sandbox" to "play" in and test, test, test and document, document, document.

We documented with great detail each step and the time it would take. We ran tests in the sandbox to ensure that the upgrade would work. It was very successful and ran into virtually no problems.

What other advice do I have?

Do some research, follow the documentation and any advise that might be out there. The Oracle communities are good sources.

Disclosure: My company has a business relationship with this vendor other than being a customer: We're partners.
PeerSpot user
it_user516738 - PeerSpot reviewer
it_user516738Works at a financial services firm with 1,001-5,000 employees
Vendor

I agree that it is helpful to group targets.

See all 3 comments
Gerente da Unidade de Negocio Oracle at a tech services company with 11-50 employees
Real User
Streamlines diagnosis of database issues, has tuning capabilities for most issues found
Pros and Cons
  • "With ASH Analytics, ADDM, Real-Time SQL Monitoring, SQL Tuning Advisor, we can measure SLAs, detect performance hotspots, perform deep diagnostics into specific tiers, tune applications, and remediate."
  • "It can also help with capacity planning, sizing, and maximizing overall performance in a large scale environment."

    What is our primary use case?

    We use Oracle Enterprise Manager primarily for database management, with a focus on performance monitoring. 

    Our environments are composed of both standalone and cluster databases which, in turn, are deployed in Oracle appliances like ODA and Exadata, as well as others hardware vendors.

    In addition, we use the tool to create, configure and manage high-availability environments using Oracle Data Guard and Real Application Clusters, automation of manual activities and patching.

    How has it helped my organization?

    With Enterprise Manager, we have achieved a dramatic decrease in the number of database incidents. As a result, unplanned downtime has been reduced because we are resolving issues before the business is even aware of them.

    What is most valuable?

    The product has powerful features for diagnosis of database issues, complemented with tuning capabilities for most of the issues found.

    With ASH Analytics, ADDM, Real-Time SQL Monitoring, SQL Tuning Advisor, we can measure SLAs, detect performance hotspots, perform deep diagnostics into specific tiers, tune applications, and remediate.

    What needs improvement?

    Oracle is always making improvements to Oracle Enterprise Manager. I think Enterprise cloud integration presents new management challenges.

    For how long have I used the solution?

    More than five years.

    What do I think about the stability of the solution?

    We always strive to have the latest version of this product, which has always helped to improve stability and performance.

    What do I think about the scalability of the solution?

    Yes, we encountered scalability issues. However, there are several techniques for achieving optimal performance. It can also help with capacity planning, sizing, and maximizing overall performance in a large scale environment.

    Inadequately-sized Enterprise Manager deployments may result in the overall benefits of Enterprise Manager being compromised.

    How is customer service and technical support?

    Good.

    How was the initial setup?

    The initial setup is pretty straightforward. Today, you can even download the templates found on the Oracle website.

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

    The basic functions are free. You only pay license fees for advanced features.

    Which other solutions did I evaluate?

    I’ve been using this product for years. I evaluated other options from different vendors such as Foglight and SolarWinds, to name a couple.

    What other advice do I have?

    To me this is the best product for enterprise database management. I rate it a 10 out of 10.

    Now, before you implement, you can do several tests with the Enterprise Manager templates VMS, available from Oracle. Also, check the compatibility matrix and try to always keep your system up to date.

    Disclosure: My company has a business relationship with this vendor other than being a customer: Platinum Partner.
    PeerSpot user
    it_user101799 - PeerSpot reviewer
    Sr. Oracle, MySQL and Teradata DBA at a tech vendor with 51-200 employees
    Vendor
    We have found that OEM has improved significantly the monitoring and tuning of our databases

    What is most valuable?

    Monitoring and tuning of Oracle databases.

    How has it helped my organization?

    It has improved significantly our monitoring and tuning of our databases.

    What needs improvement?

    Installation and configuration.

    For how long have I used the solution?

    6+ years

    What was my experience with deployment of the solution?

    Yes, configuration is a pain.

    What do I think about the stability of the solution?

    Nope

    What do I think about the scalability of the solution?

    Nope

    How are customer service and technical support?

    Customer Service: 4 stars, sometimes support takes time to figure out the issue and provide a solution.Technical Support: 4 stars

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

    Used to monitor manually before.

    How was the initial setup?

    Medium difficulty

    What about the implementation team?

    In-house

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

    None

    Which other solutions did I evaluate?

    None

    What other advice do I have?

    Go for it and utilize all the features!
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user2652 - PeerSpot reviewer
    it_user2652Project Manager at a non-tech company with 10,001+ employees
    Top 20Vendor

    You marked technical support as 4. Can you please share an example where you had a delayed response or difficulty in getting support from Oracle?

    See all 2 comments
    PeerSpot user
    Head of Data Analytics at a manufacturing company with 51-200 employees
    Vendor
    Drastically reduced our diagnostic time and helps us monitor multiple instances

    What is most valuable?

    The performance console is a must.

    How has it helped my organization?

    Can drastically reduce the diagnostic time and help monitoring multiple instances. Be aware that a lot of the features need appropriate licensing.

    What needs improvement?

    I would say the footprint on the server. Also the GUI can be tricky.

    For how long have I used the solution?

    More than 7 years

    What was my experience with deployment of the solution?

    To uninstall I needed to refer to the documentation.

    What do I think about the stability of the solution?

    No and it's a good point.

    What do I think about the scalability of the solution?

    No.

    How are customer service and technical support?

    Customer Service: Very good.Technical Support: Very good.

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

    I used ignite8 which is a must have for the perf part and a lot cheaper.

    How was the initial setup?

    It requires some reading but nothing is too complex.

    What about the implementation team?

    Myself.

    Which other solutions did I evaluate?

    Yes, quest spotlight- too messy. Nothing like AWR.

    What other advice do I have?

    Give it a try with the version embedded within the database and then go further.
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user83598 - PeerSpot reviewer
    it_user83598IT Manager at a tech services company
    Consultant

    Hello,

    You mentioned in deployment issues : To uninstall I needed to refer to the documentation.
    So can you please share your thoughts on Installation part ?

    See all 3 comments
    it_user436104 - PeerSpot reviewer
    Data Modeler at a financial services firm with 1,001-5,000 employees
    Vendor
    The most valuable feature is the ability to manage all the databases, hardware, and middleware from one pane of glass.

    Valuable Features

    From my experience, I'd say that the most valuable feature is the ability to manage all the databases, hardware, and middleware from one pane of glass.

    Improvements to My Organization

    Having the single-pane-of-glass manageability of our database, hardware, and middleware infrastructure gives us the most efficient way to keep our thumb on the pulse of the infrastructure to ensure it's always up and running.

    Room for Improvement

    OEM needs to be a little bit faster. That's probably because the features that they've developed and put into the latest product are incredible. They're consolidating more and more, which, expectedly, slows it down.

    Use of Solution

    I've been using Oracle Enterprise Manager for the last eight to ten years.

    Deployment Issues

    We've had no issues deploying it.

    Stability Issues

    At the beginning it was in the development phase, but for the last, probably six years, it's been a fairly solid product from 10g right through to the current 12c version.

    Scalability Issues

    I haven't really had to scale it because the enterprise isn't large enough to require that, but the initial installation is sufficient for all the needs.

    Customer Service and Technical Support

    I've always been very happy with Oracle support. I think probably the one thing that I'd like to be able to have more of is input into the feature set for the next release.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user435981 - PeerSpot reviewer
    Programmer/Analyst at Lidestri Foods
    Vendor
    The most valuable feature is that it goes hand-in-hand with our EDI. There are performance issues that we see tied to SOA Suite and the B2B functioning.

    Valuable Features

    The most valuable feature of OEM is that it goes hand-in-hand with our EDI. Essentially, it allows us to operate the SOA Suite solution on a management level.

    Improvements to My Organization

    The biggest improvement Enterprise Manager has provided us is that it allows for easy maintenance and setup of our user base that's surrounded by SOA Suite.

    Room for Improvement

    The issues we've had with Enterprise Manager go hand-in-hand with our issues with SOA Suite. There are performance issues that we see tied to SOA Suite and the B2B functioning, all of which impacts Enterprise Manager.

    Deployment Issues

    We've had no issues deploying it.

    Stability Issues

    There have been no problems with its own instability, just with performance that's tied to SOA Suite.

    Scalability Issues

    We don't have that many functional users using it, so scaling has not been a true issue for us.

    Customer Service and Technical Support

    We use a third-party hosting solution. A lot of the setup in technical maintenance is all handled through them. I know we've logged several SR's for the OEM issues related to the SOA Suite issues.

    Implementation Team

    This was set up through our third-party implementer.

    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: May 2025
    Buyer's Guide
    Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros sharing their opinions.