The GUI interface for monitoring and managing databases is the most valuable feature.
Division Officer at a government with 10,001+ employees
Automated alerts tell me when I have an issue before a user calls.
What is most valuable?
How has it helped my organization?
The automated alerts tell me when I have an issue before a user calls. They are proactive.
What needs improvement?
We use it mostly for the connection to the databases. It could be the version I'm on, but we seem a little limited on what we can do for monitoring for the middleware.
What do I think about the stability of the solution?
No stability issues.
Buyer's Guide
Oracle Enterprise Manager
November 2024
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
What do I think about the scalability of the solution?
So far, it has scaled well for our needs.
How are customer service and support?
Most of the time, when we open a ticket, we are happy with the resolution and the timing of the response. We've had a few incidents where they immediately say, “Maybe you should upgrade.” That usually kind of sets me off. It's like, why don't you listen to the entire thing before you immediately tell me to upgrade? Overall yes, no issues with that.
Which other solutions did I evaluate?
What other advice do I have?
Go to training first. We did it the other way around: We tried to figure it out, and then go to training. That’s fine, as long as there isn’t a big gap between when you're going to implement it, and when you've been trained. We probably would have saved a lot of angst and issues if we were properly trained first.
Our biggest issue is learning all the features. There are more bells and whistles than we're probably using; getting familiar with the capabilities, and then actually being able to execute them.
I'm happy with it. I think we're not leveraging it enough, but for what we use it for, it's perfect.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Oracle Applications DBA/UNIX SA at a agriculture with 1,001-5,000 employees
It's great being able to see that all the information you need is in front of you on the screen.
Valuable Features:
I find it nice that OEM provides a graphical way to manage both our database and E-Business Suite. It's great being able to see that all the information you need is in front of you on the screen. There are links that allow you to kill sessions or to check your performance. With other solutions, you just see numbers go by on a screen.
Improvements to My Organization:
It helps me do my job as a DBA. Even though I may know how to manage it wth the CLI, I'm much quicker at doing things and identifying problems. Having it running and seeing a spike on the graph lets me know that we have a performance issue, I've got something locked up, and I need to address that proactively instead of being reactive. Sometimes I go to the CLI to get right to the thing quicker, but the graphical interface, again, is nice.
Room for Improvement:
It can be a process hog sometimes. When I do leave it running, the CPU fan kicks on, and I can hear it running. Otherwise, it's a great tool.
Deployment Issues:
We've had no issues with deploying it.
Stability Issues:
It's been stable. We haven't had any instability issues to speak of.
Scalability Issues:
It's been scaling just fine. We have no issues scaling it for our needs.
Initial Setup:
It's easy, very easy to set up. You've got to know what you're doing, but it's not a lot. You've just got to follow the documentation and configure it accordingly.
Implementation Team:
We implemented it ourselves with our in-house team. It was pretty straightforward.
Other Advice:
Follow the directions as the setup and implementation are all nicely laid out for you.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Oracle Enterprise Manager
November 2024
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
816,406 professionals have used our research since 2012.
Manager of Oracle Technology/DevOpsManager at a retailer with 1,001-5,000 employees
It is intuitive when it comes to performance tuning, metrics, and monitoring.
Valuable Features:
In my opinion, without Enterprise Manager no DBA can do their job. There are better tools out there, but they only complement OEM because it may not do the whole job. OEM, though, is very intuitive when it comes to performance tuning, metrics, and monitoring.
Improvements to My Organization:
Without it, it's like driving a car without seeing with your eyes. Without OEM, I can't troubleshoot any of the issues that arise. For the Automatic Database Diagnostic Monitor, port reports, memory advisors depending on load, manual memory management and other database analyses that SGAs and PGAs expect -- these are all things that can only be provided by OEM.
Room for Improvement:
It's quite user-friendly when integrating, but when propagating user access and agents, it's not so intuitive. I'm using 12.1.0.3, I believe, and there seems to be a log of bugs that haven't been worked out.
Deployment Issues:
The issues with deployment in 12.1.0.3 have to do with user access and agents. Other than that, it deploys fine.
Stability Issues:
It is buggy in certain process, but every Oracle product has bugs, although unless you really hit it you would never really come to know about it. For example, one of the Java processes within OEM chews up the entire CPU. This is an obvious bug, but there is a patch that can be applied to correct the issue.
Scalability Issues:
It scales with out issues for us.
Initial Setup:
Deploying agent is not easy, but the rest of setting up is fairly easy.
Implementation Team:
We implemented it ourselves with our in-house team.
Other Advice:
You need OEM if you are having Oracle databases. OEM is very expensive, but it does some nice things like memory advisors and ADDM reports. There are products that complement OEM, but they can't replace it.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Consultant at a tech services company with 10,001+ employees
Oracle Enterprise Manager for hybrid cloud monitoring
This post is syndicated from https://johanlouwers.blogspot.com/2013/07/oracle-enterprise-manager-for-hybrid.html
Cloud computing comes in many forms, in some cases cloud computing is “just” another form of hosting and it is considered an IaaS (Infrastructure As A Service). In this cloud computing model some of your servers / systems will be located within the cloud of a cloud vendor. Amazon is a good example of this. By having your servers in one or more cloud and some (or none) located in your traditional datacenter you start creating a hybrid cloud model.Having a hybrid cloud model provides you the options to make sue of the best of breed hosting options. This can be a big advantage however in some cases also brings a challenge. Even though everything can be hosted somewhere in a cloud you most likely would like to have a unified monitoring in place which gives you a holistic view of all your servers and services.
Monitoring capabilities, which provide you a holistic overview of your Enterprise IT assets are provided for Oracle products and none Oracle products by Oracle Enterprise Manager. Oracle Enterprise Manager provides you with options to monitor hardware and software within your Oracle landscape and also maintain it from the same console.
Oracle is providing a great, out of the box, solution when monitoring your on premise IT assets and it can even monitor in multiple datacenters when you have a dual or triple datacenter setup. However, in some cases you have servers running within the Amazon Web Service (AWS) hosting cloud. This is a trend that is seen more and more within the corporate world. Even though some of your servers are running at AWS you still want to include them in your default monitoring tool, Oracle Enterprise Manager and be able to monitor the complete hybrid cloud setup.
In the above example you can see how we leverage an already available tunnel between the enterprise datacenter and AWS to ensure that the OEM connection is secured and encrypted on a network layer. Connecting the datacenter and AWD in such a manner is common practice and when connecting Oracle Enterprise Manager to the servers in AWS you can leverage this tunnel to do so.
Oracle is providing a plugin for this in the Oracle Enterprise Manager extensibility exchange. This plugin is developed by Oracle to monitor the AWS services and by doing so provide you a single monitoring console.
- Support for monitoring the following Amazon Web Services:
- Amazon Elastic Block Store (EBS)
- Amazon Elastic Compute Cloud (EC2)
- Amazon Relational Database Service (RDS)
- Rich and exhaustive list of metrics. Metrics are collected remotely using the Amazon Web Services Cloudwatch API.
- Detailed configuration information.
- Custom Home Pages with charts and AWS configuration information.
- Raise alerts based on thresholds set on monitoring data.
The plugin is available for Oracle Enterprise Manager 12.1.0.2.0 and later. More information can be found at the Oracle Enterprise Manager exchange website, the documentation can be found here.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Enterprise Systems Engineer at Sybyl
Granular, insightful, and easy to implement
Pros and Cons
- "It's easy to implement as it's made by Oracle for Oracle."
- "Technical support could be faster."
What is our primary use case?
I've used the solution for monitoring. It looks at if something is slow, which processes are taking the most resources, if it's up or if it's down, et cetera.
What is most valuable?
I like how you can drill down to a problem, like which specific query is causing the most workloads, which user has issued that query, what's taking up the most resources, et cetera.
It's easy to implement as it's made by Oracle for Oracle. Yeah. It's very insightful when it comes to what you can check healthwise on a database.
What needs improvement?
Technical support could be faster.
For how long have I used the solution?
I've been using the solution for three years.
What do I think about the stability of the solution?
It's fairly stable. It doesn't disappoint. There are no bugs or glitches and it doesn't crash or freeze.
What do I think about the scalability of the solution?
The product is scalable in terms of how much better business you can monitor. You can really just keep adding them.
I know of six users of the solution in our organization. That said, I am sure we can add more if we need others. If we add new employees, we will increase usage.
How are customer service and support?
Technical support is good. That said, they take a lot of time before they start acting upon an issue.
How was the initial setup?
I did not handle the initial setup of the solution.
That said, I understand that it is simple to implement.
I can't speak to the deployment or how long it took.
What about the implementation team?
The entire implementation was done in-house.
What's my experience with pricing, setup cost, and licensing?
There is a license that is required, however, I cannot speak to the exact cost.
What other advice do I have?
I'd rate the solution nine out of ten. We are quite satisfied with its capabilities.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Oracle DB A
I'm able to monitor the cluster levels; all the information is consolidated in one place
Pros and Cons
- "I mostly use the top events, and look at how the execution is happening on the database; and monitoring the cluster level rates. I even look at the execution plan."
- "I would say mostly backup and recovery, through the Enterprise Manager. Or any corruptions, to be able to fix them through Enterprise Manager."
What is most valuable?
I mostly use the top events, and look at how the execution is happening on the database; and monitoring the cluster level rates. I even look at the execution plan.
I really love this tool because I don't need to type the commands. It's very user friendly, I just click and get the reports and get it done.
How has it helped my organization?
It does help a lot because we have a centralized place, we can go there and monitor all the databases or whatever else we need to. It's in one place. We can monitor everything.
What needs improvement?
I would say mostly backup and recovery, through the Enterprise Manager. Or any corruptions, to be able to fix them through Enterprise Manager.
What do I think about the stability of the solution?
In terms of stability, I'm pretty confident. I'm very happy with the product.
What do I think about the scalability of the solution?
Scalability is pretty good. We have everything monitored using Enterprise Manager.
How are customer service and technical support?
We get our support through the Oracle Support help desk ticketing system. It's good.
We have two types of support. One is an on site person, from Oracle. The other option is that we can create a ticket through the online support.
Which solution did I use previously and why did I switch?
Previously I was using all command-based, I needed to manually run things, but now I don't need to. Now, whatever I need, I can go and find it.
The switch was a company decision.
How was the initial setup?
It was already set up in our datacenter, another team is managing it, but we are using it.
What other advice do I have?
When looking at a vendor the most important criterion I'm focused on is timely support. A person available, and the ability of the person in support to fix the problem immediately. I also prefer anyone that is a market leader or that has a lot of options, and they know what they're doing.
I give it an eight out of 10 because I still feel that there are more improvements that need to be done.
Go use it first and see whether it's meeting your requirements. Then, if you're happy, go from there.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
DB Manager at Secure-24
we have a thousand databases and the way you can get to the metrics, quickly figure out the ETA to fix a problem, these are the things that I love.
Pros and Cons
- "I think the look and feel and the accessibility to the databases, the scale of environment support."
- "We could use it but definitely with some effort we can streamline much better and sometimes some box here and there, like 13C you have to really wait, but there are great features. Just have to make sure it is a stable product."
What is most valuable?
I think the look and feel and the accessibility to the databases, the scale of environment support. Ours is basically like a hosting company and we have a thousand databases and the way you can get to the metrics, quickly figure out the ETA to fix a problem, these are the things that I love.
How has it helped my organization?
As I said, ours is a hosting company. We host a lot of customer environments in our data center and pretty much the alerting mechanism and the deviates stay on top of things with using the ... applying patches, for example.
We can do things on the fly and templates and the monitoring, the way the alerts kick in. We can pretty much make generic and customize based on customer needs and it takes less deviate time I would say, even down time or when you want to set those blackouts when you are working without the teams. It is pretty straightforward.
What needs improvement?
I think maybe we have to streamline further. It is just that everything out of the box. It is not really...
We could use it but definitely with some effort we can streamline much better and sometimes some box here and there, like 13C you have to really wait, but there are great features. Just have to make sure it is a stable product.
What do I think about the stability of the solution?
No.
What do I think about the scalability of the solution?
No.
How is customer service and technical support?
Yeah, sometimes we see little things that are getting dragged with Oracle support and all that. I think overall they are fine.
What's my experience with pricing, setup cost, and licensing?
I think training is not required unless you are really low rating all the great features. I would recommend getting them certified, OEM certification, 12C certification. That would help.
Which other solutions did I evaluate?
Quest products is one that I can think of.
Quest I don't think looks it at such a larger scale and we integrated Oracle's OEM service now and that also helps us. We liked the internal views which pretty much covers all the environments, also the OEM internal which captures the database. We call that database repository.
What other advice do I have?
I would definitely recommend it. Yeah, just get the stable product right now, 12C, and probably 6 months down the line I could even recommend 13C.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Works at a energy/utilities company with 10,001+ employees
Allows you to manage databases via groups. Performance tuning tools need improvement.
What is most valuable?
- Managing databases via groups
- Running AWR and ADDM reports is simple and quick.
- Performance graphs are good to share with application teams and database users.
How has it helped my organization?
Warnings and alerts are sent to the primary DBA. Primary DBAs address the alerts in a timely manner, instead of waiting for it to become an issue.
What needs improvement?
Performance tuning tools need improvement.
For how long have I used the solution?
We have been using this for five years.
What do I think about the stability of the solution?
The system has minimal issues with stability. The system has about 1500 databases currently.
What do I think about the scalability of the solution?
There are no issues with scalability. the system is stable with about 1500 databases.
Which solution did I use previously and why did I switch?
The software was acquired as part of merger.
What about the implementation team?
Software was acquired via a merger and was already online. Our databases were added to the system.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
Quest SharePlex
Quest Foglight for Databases
SolarWinds Database Performance Analyzer
Quest Spotlight
Toad for Oracle
Nutanix Database Service
Toad Data Modeler
IDERA SQL Diagnostic Manager for SQL Server
IBM InfoSphere Optim
Oracle Coherence
EDB Postgres Enterprise Manager
SolarWinds Database Performance Monitor
Buyer's Guide
Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Can someone please share if they did a vendor comparison, why they chose Oracle Enterprise Manager?
- How do the various System Monitoring solutions compare?
- Oracle Enterprise Manager vs. Foglight for PeopleSoft Applications?
- What is the difference in license models of these Oracle products: OCI APM and OEM APM?
- What is the best GUI tool for development and management of a PostgreSQL database?
- What is the best backup solution for Sybase ASE 15.5?
- Which Database Activity Monitoring tool is best for cloud environments?
- What are your top recommended replacement solutions for Quest Foglight for Databases?
- Which low-code (no-code) database solution do you prefer?
Hi Johan,
We currently have a small data center operations environment, having only fewer than 10 servers. However, we do have Oracle Peoplesoft Campus Solution deployed on a fully-virtualized system on a Cisco UCS blade server system. Our application servers are Oracle, but our back-end database is MS SQL Server. We currently don't have any application performance monitoring and asset management solution.
Would you recommend Oracle Enterprise Manager for this relatively small set-up? We are also looking at MS System Center Configuration Manager, but I think this is a better product considering the Oracle system that we have. I'm quite impressed with the reviews of this product here on IT Central Station and looking for valuable advise on this.