Oracle Database Administrator Senior Team leader at a financial services firm with 10,001+ employees
Real User
Good monitoring and management of our Oracle products, but consolidating everything into a single dashboard would be better
Pros and Cons
  • "The product gives us as much control as we can have by providing a complete picture of the whole set of Oracle products."
  • "We would like to have a single dashboard for monitoring and controlling all of our products."

What is our primary use case?

Our primary use is for monitoring and management of Oracle products. We are running several Oracle products in our environment.

What is most valuable?

The product gives us as much control as we can have by providing a complete picture of the whole set of Oracle products. We can monitor all of them.

What needs improvement?

We would like to have a single dashboard for monitoring and controlling all of our products. This would add value, for us, because as it is now, we have to go to different screens to check different products.

For how long have I used the solution?

We have been using Oracle Enterprise Manager for about seven years, since 2013.

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

What do I think about the stability of the solution?

The Oracle Enterprise Manager is pretty stable and we haven't had any issues.

How are customer service and support?

We have not had to contact technical support for this product because we haven't had any issues. However, if we need to then there is a support portal available.

How was the initial setup?

This product is easy to install and we can complete the deployment in a day, including the agent.

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

We are satisfied with the pricing.

What other advice do I have?

Overall, I am satisfied with this product. It assists us in finding issues through monitoring services.

I would rate this solution a seven out of ten.

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.
PeerSpot user
it_user522051 - PeerSpot reviewer
Is Business Analyst at Emerge
Real User
Facilitates data capture and processing based on what we need for analysis

What is most valuable?

The ability to capture data and then processing it based on what we need to pull for analysis.

How has it helped my organization?

  • Less manual work
  • Less labor intensive
  • More data consistency

What needs improvement?

More flexibility in terms of the user being able to customize a little bit instead of having it so standard. That would be helpful.

What do I think about the stability of the solution?

It's been pretty stable. It's good.

What do I think about the scalability of the solution?

For us, it's a good size. It applies to all populations. It's good.

How are customer service and technical support?

For technical, we have a technical team. Usually, because I'm an analyst, I just pass it over to the technical team and they deal with the technical side.

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

It was an old system. That's why we transferred into this. In technology, you need to be advanced. You need to keep up.

The decision was made by top management, but I'm sure that they look at cost and the support of it. Mainly the cost.

How was the initial setup?

I think the initial setup was not too complex. It wasn't that bad.

What other advice do I have?

We went with Oracle because we were looking for stability, a vendor that is reliable, being able to get help, troubleshooting when there's a problem. I think those are the important ones.

I would recommend looking into it.

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
April 2024
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
770,765 professionals have used our research since 2012.
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
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_user522069 - PeerSpot reviewer
DB A at a university with 1,001-5,000 employees
Vendor
Real-time alerting allows me to get right on issues and correct them as quickly as possible

What is most valuable?

Performance diagnostics. That is the best.

How has it helped my organization?

It allows me to receive real-time alerting notifications when somebody's doing something that is detrimental in the environment. I can get right on issues and correct them as quickly as possible.

What needs improvement?

It's a pretty well-rounded product. Nothing really comes to mind right now.

What do I think about the stability of the solution?

Very stable, extremely stable.

What do I think about the scalability of the solution?

The ability to scale is excellent.

How are customer service and technical support?

Outstanding.

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

We weren't using anything previously. The decision was just made to go with this one because I was familiar with it, and it's a pretty solid stable product from Oracle.

How was the initial setup?

The setup was moderate, but the documentation and everything that exists is really invaluable.

What other advice do I have?

In choosing a vendor our most important criteria are affected by the fact that we work for the Children's Hospital Research Institute. They're a non-profit so budgets are always tight. Cost would be the primary factor, and vendors being willing to negotiate, for non-profit companies, on the prices.

Be sure that you have the people with the skill sets to be able to use the tool, or be willing to invest in the training to learn how to use the tool.

It's a more mature stable product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521547 - PeerSpot reviewer
Senior System Analyst at a aerospace/defense firm with 1,001-5,000 employees
Real User
The database monitor is the most valuable feature for us. System response is too slow.

What is most valuable?

Monitoring of the database is the most valuable feature, because we want to know what's going on there.

How has it helped my organization?

It is timely, if you want to add some memory or whatever. That's seems to be timely.

What needs improvement?

I don’t think the response system is that good. It is too slow.

What do I think about the stability of the solution?

It's pretty stable.

What do I think about the scalability of the solution?

Scaling requires a little more configuration work.

How is customer service and technical support?

I have not had to use technical support.

How was the initial setup?

Initial setup is pretty straightforward.

We don't integrate it with anything else. It runs as a standalone piece.

What other advice do I have?

The monitoring product is getting better every year, but it still needs some work.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Database Senior Manager at a financial services firm with 1,001-5,000 employees
Vendor
Excellent in monitoring and the ability to quickly drill down, see and identify issues. Smooth initial deployment.

What is most valuable?

Monitoring and the ability to quickly drill down, see and identify issues. Also provisionning is an interesting option as long as it works.

How has it helped my organization?

We have set up a lot of alerts which can notify us immediately when something arises and this is keeping our SLA's kept. Additionally we have made customized reports on KPI's in order to quickly get the whole picture and keep management apprised - also so we can show how a change has made an impact.

What needs improvement?

Setting up provisioning can be a challenging. Also there are a lot of bugs and some specific to platforms. Not every platform is equally supported.

For how long have I used the solution?

Personally 6 years, in the company more than that (from version 9 up to 12c)

What was my experience with deployment of the solution?

With the initial deployment no, went smoothly for the last version. In the previous there were some issues that were frustrating but in the end not so hard to overcome.

What do I think about the stability of the solution?

Initially after the upgrade/installation of every version we have had issues with stability and performance. After a couple of weeks tuning and tweaking it stabilizes and then we have no more trouble - till the next upgrade.

What do I think about the scalability of the solution?

No, we have not had any issues. That is probably because at a point we decided to set up a second installation for our test environments and we have divided the workload between the two installations.

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

Before using OEM we had a lot of scripts to check database health, also we have and use some other solutions for monitoring. OEM provided everything in a single package and has a lot more options, plus it is a lot better at monitoring databases then anything else.

How was the initial setup?

With every version it becames easier to set it up. Depending of course on the platform, but still with 12c it is really straight forward.

What about the implementation team?

We tried to involve Oracle for a upgrade and migration project from version 11g to 12c. After more than a year finally they gave up and said it cannot be done. We then did it in-house, workaround it (with their support of course) we migrated the 11g version and then upgraded it. Every other upgrade/installation was done in-house.

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

Sorry can not say about the cost, we have always used as little hardware as possible.

Which other solutions did I evaluate?

Not a lot. Mainly we looked at what we have and then went for OEM as most of our DBs are Oracle. We have monitoring from HP BAC/Mercury.

What other advice do I have?

It is a must if you have more than a couple of databases to monitor and manage, it can also do a lot of other stuff and monitor various types of targets. It has a good system for testing applications. It has a lot of potentials but best advice is read through the documentation and know what you are getting, check with somebody who is already using it to get the best idea.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user82773 - PeerSpot reviewer
Database Expert at a energy/utilities company with 10,001+ employees
Real User
Gives us the real monitoring and alerting we need to monitor our database ecosystem from one tool

Valuable Features:

Real-time monitoring we can quickly find the session or queries that are causing issues.

Improvements to My Organization:

With our different platforms running our databases like UNIX, Linux and Windows it becomes difficult to support manually with different type of scripts. With different types of database versions like 9i, 10g and 11g it helps to have one tool that can support them all.

Room for Improvement:

One thing I would like to see is the option of agent less monitoring. I would also like to see monitoring only at LDOM level so if you are using Solaris zones you only monitor at LDOM level.

Use of Solution:

I've been using OEM since version 10g which would have been since 2007.

Initial Setup:

The setup is straightforward the installer guides you during the installation. The installer also has pre-checks to make sure your system is ready for installation or upgrade. For upgrades you have the option of a 2 step system for if you want to move to another server and OS at the time of your upgrade from older versions.

Other Advice:

I would recommend that you try OEM, it can monitor many different products and it has been well designed. When monitoring database performance in real-time I have yet to see another product that can do it as well as OEM.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user3876 - PeerSpot reviewer
it_user3876Database Manager at a tech company with 51-200 employees
Vendor

What alternative solutions you have used beside OEM and in which area of customer support you are seeking improvement?

See all 2 comments
Buyer's Guide
Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Buyer's Guide
Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros sharing their opinions.