Try our new research platform with insights from 80,000+ expert users
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
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 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 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_user83301 - PeerSpot reviewer
Consultant at a tech services company with 51-200 employees
Consultant
OEM makes sense for my customers’ needs and makes it easy for me to immediately resolve any problems that arise

Many of our company’s customers have multiple databases. Thus they often need help determining how to consolidate them, monitor them and move forward with their business plans. I bring insight to these customers by showing them how to optimize their IT environments. When it comes to helping customers identify best practices, 90 percent of the time I end up talking about Oracle Enterprise Manager. Many of these customers have adopted Oracle Enterprise Manager 12c as their primary monitoring platform.

I recall a situation with an Atlanta-based tax services company that required extremely high availability during the busy tax season (approximately December 15 and April 15). We had to uphold very strict service level agreements that carried serious penalties and huge financial implications. An unscheduled outage of one hour leads to a $1 million fine. Previously this company used five separate monitoring tools, which was causing extra effort for system administrators and was a source of concern regarding unplanned down time. I spent a few days helping these administrators understand the full potential of a centralized monitoring and management solution based on Oracle Enterprise Manager. It took some convincing and it came down to setting them up with a prototype for the next tax season. Using the new system, they had zero problems and were impressed with the stability. After that, they decided to standardize on Oracle Enterprise Manager as their system management foundation going forward.

I implemented the Oracle Enterprise Manager Database Lifecycle Management Pack, complete with the configuration and change management features, simplifying the Sarbanes-Oxley compliance work necessary for this company’s large government customers. Now they can see what is changing in their environment all the time, which gives them a real-time glimpse into the security of the database. This company’s senior management admitted that without Oracle Enterprise Manager their tax season would not have gone successfully. Day and night, if there were issues, we were notified and we resolved problems immediately.

My take on OEM 12c is that I especially like the performance tuning features since they let DBAs identify problems very quickly. The real time ADDM (Automatic Database Diagnostic Monitor) and associated reports let me drill down into these issues without having to prepare snapshots. I can identify and resolve issues immediately. I also likes the Oracle Enterprise Manager Consolidation Planner, which I find to be an extremely flexible and valuable tool. For example, if a client wants to move to an Oracle Exadata system, you can use the Oracle Enterprise Manager Consolidation Planner to identify precisely how big of an engineered system that client will need. This tool simplifies requirements gathering when you are consolidating to engineered systems.

I recommend Oracle Enterprise Manager because today’s DBAs are being asked to do more with the tools and resources that we are given, to drive change within the organization so that IT teams are more knowledgeable and efficient. Oracle Enterprise Manager empowers database administrators to resolve problems quickly—to identify bottlenecks and pinpoint performance issues. Many DBAs still like the command line, but in my experience the GUI makes it twice as fast to resolve issues. This insight is especially helpful at the outset of a project. Too often DBAs don’t get called in until the end of the development cycle, as somebody who can run the database. But ideally they should have input on the front end of that cycle, while there is still time to identify issues with the SQL code or with other aspects of the hardware or software infrastructure. DBAs can drive the changes that optimize applications and make databases run better.

I believe some Oracle customers are slow to adopt cloud models simply because they don’t realize that Oracle Enterprise Manager can help pave the way. It’s an enterprise tool, not just a database tool. Once organizations understand that Oracle Enterprise Manager can help them manage their whole stack they will realize how much it can help in the context of deploying and managing clouds. Deploying a private cloud is often the first step towards a database as a service environment in which developers can provision databases themselves via a self-service portal. This model has the potential to fundamentally change the way developers do things. You can click a button and clone a database. This will shorten the development cycle, especially with Oracle Database 12c, which lets you provision a pluggable database quickly from a multitenant architecture. Developers can provision what they need and move on. I believe that championing these database as a service environments will elevate the role of DBAs. They can lead their organizations to embrace a new type of fast, efficient provisioning. This will make DBAs more important to the development cycle and push them to the front-end of many projects.

Disclosure: PeerSpot has made contact with the reviewer to validate that the person is a real user. The information in the posting is based upon a vendor-supplied case study, but the reviewer has confirmed the content's accuracy.
PeerSpot user
it_user83598 - PeerSpot reviewer
it_user83598IT Manager at a tech services company
Consultant

Hello Bobby Curtis,

Nice Article, very well explained, through this article I came to know how OEM can solve complex business process.
And I request you to provide some more information on OEM Consolidation Planner.

See all 2 comments
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.
reviewer1428951 - PeerSpot reviewer
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.

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