Try our new research platform with insights from 80,000+ expert users
Senior Enterprise Database Engineer at Genesis Financial Solutions, Inc.
User
It has eased the responsibilities among our DBAs
Pros and Cons
  • "I have found the singular GUI feature very helpful. Fewer DBA resources can be allocated with Toad licenses."
  • "Oracle Enterprise Manager has eased the responsibilities among our DBAs. We can now assign individual tasks to separate DBAs."
  • "They should improve the hover text context. This would provide assistance whenever a task is attempted by a DBA."

What is our primary use case?

I use Oracle Enterprise Manager for database administration and to manage our IT help desk. It is also used to scope database issues which need support in a production environment.

How has it helped my organization?

Oracle Enterprise Manager has eased the responsibilities among our DBAs. We can now assign individual tasks to separate DBAs.

What is most valuable?

I have found the singular GUI feature very helpful. Fewer DBA resources can be allocated with Toad licenses.

What needs improvement?

They should improve the hover text context. This would provide assistance whenever a task is attempted by a DBA.

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.

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.
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
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.
PeerSpot user
Oracle Consultant & DBA - Cloud Support Engineer at Amazon Web Services
Consultant
Top features are the ability to consolidate information and access to my databases into a single portal

What is most valuable?

Consolidate information and access to my databases into a single portal.

How has it helped my organization?

We increased our capacity and speed of detection, diagnose & resolution of database issues.

What needs improvement?

UI is the part that I like to see improved in the future.

For how long have I used the solution?

I have been using EM for almost 6 years.

What was my experience with deployment of the solution?

Not so much, and all easily fixed.

What do I think about the stability of the solution?

Not in version 12c, EM uses Database 11gR2 and WebLogic that both have superb stability.

What do I think about the scalability of the solution?

None and, in case of need, we can always add another WebLogic Server or another node to the database tier.

How are customer service and technical support?

Customer Service: Oracle Support is very good most of the time.Technical Support: You start with junior technicians, but you can escalate if necessarily.

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

No, previously we used Enterprise Manager Database Console, that is a local DB console.

How was the initial setup?

We're used to Oracle products, so the deployment wasn't complex at all.

What about the implementation team?

We did the implementation ourselves.

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

I don't have a money estimate, but in man-hours, a deploy in a single machine, for an estimate of 100 targets, takes 8 hours.

Which other solutions did I evaluate?

Yes, we evaluated Pandora, Nagios and Zabbix.

What other advice do I have?

Follow the installation guide step by step, there won't be any surprises. Check your memory, CPU & disk requirements before implementation.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Manager DBA at a healthcare company with 1,001-5,000 employees
Real User
We checked various Monitoring software but OEM provided us with the greatest ability for productivity

How has it helped my organization?

We have 200+ databases and monitoring that number of databases without using a enterprise tool would involve a tremendous amount of manual work. Furthermore, early notification about databases and operating system alerts helps our DBA team in fixing the issue before there is any major impact on the business.

What is most valuable?

Database performance monitoring, dashboards, databases management and Dataguard setup and monitoring are the features that I like the most.
BI Publisher is another cool feature to generate customized reports.

What needs improvement?

Middleware (weblogic) has some bugs and crashes occur which should be fixed to make OEM more productive.

This

For how long have I used the solution?

I have been using OEM for 6+ years

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

We were using custom build application to monitor the systems but this product provides more functionality and GUI interface.

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

We have an enterprise Corporate License so cost is not an issue.

Which other solutions did I evaluate?

We checked Quest software (Spotlight and Toad) however we found OEM to be more productive.

What other advice do I have?

I feel that this a 5 star product because of how easy it is to configure and the vast features that are available.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user516651 - PeerSpot reviewer
it_user516651Works with 1,001-5,000 employees
Vendor

OEM helps monitor across heterogenous systems which is key for big companies with various prod environments.

See all 2 comments
it_user522057 - PeerSpot reviewer
DBA at a pharma/biotech company with 1,001-5,000 employees
Vendor
Monitors all our Oracle infrastructure and as a DBA I also use it for SQL monitoring
Pros and Cons
  • "It's user friendly."

    What is our primary use case?

    We primarily using this for the monitoring, it monitors all our Oracle infrastructure. As a DBA I also use it for SQL monitoring and for performance tuning analysis.

    What is most valuable?

    It's user friendly.

    How has it helped my organization?

    We have Oracle Accelerator. We heard this is a better tool for monitoring Accelerator. But it's more than monitoring just that, we have extended the monitoring to DB2 and SQL Server platforms.

    What needs improvement?

    I think they have already listed some things in 13c. I heard it includes a couple of features we are looking for like monitoring templates. I want to explore those features. Probably they will be included in 13c.

    For how long have I used the solution?

    We have been using it for the last three years.

    What do I think about the stability of the solution?

    It is pretty stable. There are some pros and cons, but we compared it to other tools which are available for monitoring Oracle databases and other products, and what we found is this is one of the best.

    What do I think about the scalability of the solution?

    It's scalable. Currently, we are monitoring close to 3000 targets and it's pretty well scalable.

    How is customer service and technical support?

    I'm a bit skeptical of it. I personally experienced a little longer time than I would like to get the right solution for issues. They have good support. It depends on the person with whom you are interacting.

    How was the initial setup?

    I would say setup is moderate, actually. It's not that difficult. If you have a good background in web logic and servers then I think it's easy. They have very good documentation in place so you just have to follow the documentation and it can be installed easily.

    What other advice do I have?

    This is one of the best tools we've had. I would advise others to go for it.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user522108 - PeerSpot reviewer
    Senior Client Partner at a tech services company with 10,001+ employees
    Real User
    It is web-based. You can access it from anywhere. Access to taxation data would be great.

    What is most valuable?

    The most valuable feature is that it is web-based. That helps us to get access from any location without being dependent on your personal laptop. You can access it from any laptop, any iPad or even iPhone; kind of everywhere.

    How has it helped my organization?

    Access to the data; you can access it anywhere. That helps us to get the information readily. That improves productivity as well.

    What needs improvement?

    Some of the new features it could give us: maybe access to some of the taxation data and also some of the other benefits it could include as part of the system. That would be useful.

    What do I think about the stability of the solution?

    My experience with the stability has been very good. I have not seen any issues. I use it for my own purposes, in a limited way, but I haven't come across any instability or not being able to access the data; it being down or anything like that.

    What do I think about the scalability of the solution?

    We’re using it for around 15,000 employees, and it is meeting our requirements. I’m not sure how much it can go up to, but at least 15-20,000, I have not seen any problem.

    How are customer service and technical support?

    I haven’t used technical support.

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

    They wanted something that was available everywhere instead of being available only on a particular laptop or PC. That was one of the reasons for it: easy accessibility.

    The first reason we chose Oracle was the feature set; it was really comprehensive. Plus, it met most of our immediate needs. That kind of led us to pick Oracle.

    When I’m looking at a vendor like Oracle, the most important factors are stability, scalability, and of course, the price. All three of them definitely help to make a decision.

    How was the initial setup?

    Initial setup was really simple: just go to the website, register, and you’re good to go.

    What other advice do I have?

    If you are looking for a solution that is accessible, because of the global nature of the workforce, I think this is a good solution.

    From the features perspective, I see there's still more that could be done, as I have mentioned.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user522192 - PeerSpot reviewer
    Oracle Database Architect at a computer software company with 501-1,000 employees
    Vendor
    We use it to monitor sites without scripting, maintain all databases in one place, and standardize code.

    What is most valuable?

    It's a standardized GUI tool, which is very good and pluggable with automatic connection to an Oracle database, in comparison with any other GUI tools available in the market. Other than that, if you see if you want to share the backups, or if you want to do any monitoring stuff, to customize your monitoring, and if you want to do the blackout. If you are doing any amendments, you can do a blackout.

    If you want to monitor the regular site without doing any scripting or anything, you just need to plug in both databases, and then it's easy to maintain. It's one tool to maintain all the databases in one place without doing much customization, and it's easy to manage.

    How has it helped my organization?

    People used to say I develop my own scripts, or colleagues used to develop their own scripts. If you want to change, if you are doing an upgrade, or if you are going to migrate your database, for example, from Linux to Solaris (REAX), then we need to change all this coding, right, to support that. I want to write my own code, and he wants to write his own code. Everybody out there wants standards to write the code. Then when you do migrate all these things, we need to do so much hard work to make it actually work. If you use OEM as a standardized tool, then it's easy to manage, and you don't need to do all this hard work, which it makes easy.

    What needs improvement?

    If you see the documentation, it's not really that much good. They did not explain all the details, so maybe they need to improve the documentation to get a better understanding, so that most of the people can use it.

    What do I think about the stability of the solution?

    Stability is good, but I can see only very small performance issues. When the system is very busy and I click a report, sometimes takes a little bit more time than I expected. If you fix those performance issues and best practices, I think it's an awesome tool.

    What do I think about the scalability of the solution?

    I was able to scale with multiple margins: small, medium, large, and extra large. We can pick those according to your organization’s size.

    How is customer service and technical support?

    Technical support is always good. The only thing we need is to create a right severity, and talk to the right folks, actually. Then problems will be resolved.

    Which other solutions did I evaluate?

    I checked the BMC Patrol and Quest products also, to monitor the databases. I feel like among all these, that OEM is the best tool compared to any other.

    What other advice do I have?

    I feel that it's a good tool. The only thing is that you need to read the documentation before starting anything. As you mentioned about the size, you need to know how may databases you want to monitor in the company, and pick the right size.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user522087 - PeerSpot reviewer
    Lead Database Administrator at Accertify inc
    Consultant
    Database environment monitoring minimizes downtime and notifies us of performance issues.

    What is most valuable?

    It monitors our database environment, which is very critical for our environment.

    How has it helped my organization?

    We are going to minimize the downtime. If the system is down, it will page us; and we're going to get to that issue. Its a very added advantage. It also tells us when the system is running slow; if some people are experiencing performance issues, we can see that. It's a very useful graphical user interface for the management to understand.

    What needs improvement?

    We want to see some of the official licensed products, the other core components that come inside so plug-ins are made easy for us.

    They've got to integrate more into the network inside. They've got to integrate more depth and provide a solutions for that. The storage system monitoring is really a little basic. They just give the symptoms, not the solutions. That's the bad thing.

    What do I think about the stability of the solution?

    The stability is good. So far, it's running perfect, so there are no complaints about it.

    What do I think about the scalability of the solution?

    I think this product doesn't have to scale much because it just monitors the database. We're keeping about one year's worth of work. We can scale according to the storage.

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

    We were using hand grown scripts as our previous solution. This has a nice GUI interface, and all that, and that's the reason we went with this.

    We didn't consider much because we didn't have any competitor for that here. We do have another product called Ignite. We were using it, and we used it also linked with this one; but they were home grown scripts we had.

    How was the initial setup?

    It's a simple straightforward tool to install. We did it 6 years ago, and we keep upgrading the work instructions. It's perfectly fine.

    What other advice do I have?

    There is online documentation. He has to go look around and see what he can get, and then implement it if he wants to.

    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.