Try our new research platform with insights from 80,000+ expert users
it_user44463 - PeerSpot reviewer
Lead Database Administrator
Vendor
As a troubleshooter, I was able to quickly resolve memory issues with this product

What is most valuable?

The speed at which I can drill down to isolate issues.

How has it helped my organization?

  • As a troubleshooter, I was able to quickly resolve memory issues.
  • Finding the top 10 longest running queries helped to control query performance issues. 

What needs improvement?

Metrics settings could be improved to be more intuitive.

Installation process could be easier. 

There could be better configuration documentation.

For how long have I used the solution?

10 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?

No issues.

What do I think about the stability of the solution?

Stability is good. No issues.

What do I think about the scalability of the solution?

I do not have a need for this product's scalability.

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

No.

How was the initial setup?

It was complex. The installation document was tough to understand.

What about the implementation team?

I installed the tool myself.

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

Get this tool.

Which other solutions did I evaluate?

Yes, DBArtisan.

What other advice do I have?

I am very happy with this tool.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user240024 - PeerSpot reviewer
Managing Director at a tech services company with 10,001+ employees
Real User
The Database Consolidation Workbench provides a flexible approach for various customer scenarios.
Pros and Cons
  • "It is a comprehensive, end-to-end solution for managing database consolidation, something that has been missing and difficult to do."
  • "It needs to support the Database versions lower than 10.2."

What is most valuable?

It is a comprehensive, end-to-end solution for managing database consolidation, something that has been missing and difficult to do. The Database Consolidation Workbench provides a risk-free and accurate approach to consolidation by eliminating guess work and human errors. Most of the errors that lead to severe issues in production environments are due to poor sizing of the configuration and so-called “educated guesses”. The Workbench provides a flexible approach for various customer scenarios: every environment is unique and several scenarios are possible.

How has it helped my organization?

Database consolidation has been for years a tedious process for many clients. The benefits are enormous. By using the Database Consolidation Workbench, companies achieve the following:

  • Reduce complexity
  • Improve efficiency
  • Lower costs
  • Better security
  • Better monitoring
  • Harmonized backups and easier restore
  • Better performance
  • Simplify maintenance
  • Fewer servers in fewer locations
  • Harmonized environment

What needs improvement?

It needs to support the Database versions lower than 10.2.

For how long have I used the solution?

I have been using the Database Consolidation Workbench since its release with OEM 13c. I am even going to give two keynote speeches over the next month at Oracle conferences in Europe. The subject is of major interest to both business professionals and technical resources.

What was my experience with deployment of the solution?

We've had no issues with deployment.

What do I think about the stability of the solution?

We've had no issues with the stability.

What do I think about the scalability of the solution?

There have been no issues scaling it for our needs.

How are customer service and technical support?

10/10

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

We used just spreadsheets and common-sense practices, which were often doomed to fail. The solution provided now by Oracle covers the last missing piece of the complete set-up when consolidating databases. One can think of Database Consolidation Workbench OEM 13c as the “Holy Grail” of Database Consolidation.

How was the initial setup?

The initial setup was more than straightforward. It's easy to set up, configure, and use.

What was our ROI?

Reasons to upgrade to Enterprise Manager 13.2: https://blogs.oracle.com/oem/e...

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

It is part of Real Application Testing, so no new investment is necessary for clients who already are already using RAT.

Which other solutions did I evaluate?

There are no products available that can be compared with Database Consolidation Workbench. Not even close.

What other advice do I have?

This is one of the most important additions to Oracle Enterprise Manager from both the business perspective and DBA point-of-view. Start first with upgrading OEM 11g or 12c to 13c as the Database Consolidation Workbench was introduced first in Oracle Enterprise Manager Cloud Control 13c as part of the Real Application Testing option. Run different scenarios within different projects in order to pick the best strategy. Always validate at the end.

Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor. The reviewer's company has a business relationship with this vendor other than being a customer: Beta tester, diamond partner, and close collaborator with Oracle development.
PeerSpot user
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.
it_user522171 - PeerSpot reviewer
Senior Manager For Application And Database Architecture at Wesco Aircraft
Vendor
It provides visibility for Oracle and non-Oracle hardware, software, and middleware.

What is most valuable?

Oracle Enterprise Manager provides a single pane of control that gives you the visibility to see all Oracle products, plus the non-Oracle products; hardware, software, middleware. It covers it all.

How has it helped my organization?

The benefits to my organization are with administration, plus it centralizes your control.

What needs improvement?

There are a lot of plugins. I would like to see more and more plugins for different software. Most of them are third-party software. If Oracle Enterprise Manager could provide a standard web service to interface with any application, that would be ideal.

I don't think anybody can walk on water. Software is buggy and that's the nature of the beast.

What do I think about the stability of the solution?

Stability is excellent now; not so much, before.

What do I think about the scalability of the solution?

Scalability is endless because you can use Oracle technology to expand the back end and also use Oracle technology to expand the front end.

How are customer service and technical support?

Technical support is very helpful. They were efficient. Usually, Oracle support is very good.

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

We previously used vendor-specific monitoring or control systems to administer different type of resources; hardware, software. OEM gives me the ability to expand that by putting everything under one control console.

How was the initial setup?

I was involved in the initial setup, and it was pretty straightforward. Over the years, they have even simplified a lot of processes. Before, you had to install this and that, but now it's just one single installation that does it all.

Which other solutions did I evaluate?

For me, choosing this solution was a no-brainer because we are an Oracle shop. From having all different types of vendors for hardware and software, we are gradually becoming an Oracle shop.

What other advice do I have?

Try to understand what OEM can do for you. Exploit it and its feature set. For example, I can modify the back-end storage through OEM. I don't have to go to my ZS4 console to see how much space I have, how to administer it, or how to allocate storage space to a particular project. I can do that through OEM. That's the power of having a single pane for control.

When I’m looking at a vendor such as Oracle, support is the most important criteria. Over the years, Oracle product has improved the stability, so that the most important thing now is how fast they can provide solutions when I need their help. That's the most important thing.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522135 - PeerSpot reviewer
IT Specialist at a government with 1,001-5,000 employees
Vendor
It monitors SQL Server components in addition to Oracle database components.

What is most valuable?

The most valuable feature is the monitoring of all of the different types of targets in our infrastructure, including not only the Oracle Database components, but the SQL Server components also, in the host.

How has it helped my organization?

We are able to manage larger numbers of databases with less human resources.

What needs improvement?

I would probably like to see more plug-ins to manage even more heterogeneous types of resources.

What do I think about the stability of the solution?

I would say 95% of the time it's up and running without any problems.

What do I think about the scalability of the solution?

It's scaled pretty well for our needs, so far. We're planning on moving over to a server that has more resources available because we are getting to a point where, with some of the features that are available – such as dealing with monitoring compliances, security compliances – it's starting to take up more resources than what we have on that server along with these targets. We're having to move off of this server to have some more resources.

How are customer service and technical support?

When I open a ticket with Oracle, it is resolved in a timely fashion. I’m happy with the resolution. They work. We have MOS. They work extensively with us to try to get resolutions as quick as possible.

I rate technical support 8/10.

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

We did have Foglight. It was providing us decent monitoring of the targets, but the OEM, specifically for managing the Oracle databases, is a lot more robust. You have more tools to work with to administer the Oracle databases.

How was the initial setup?

I was involved in deploying and setting it. It was very straightforward and I set up all three of the tiers, from the web to the application to the back-end database. We have them running on just one server, but it's providing what we need out of it. We're currently managing approximately 900 targets.

What other advice do I have?

It's a very robust tool. You will find there are many links and it's easy to navigate, but it might take you some time to learn where everything's at.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521859 - PeerSpot reviewer
Enterprise Architect at Revenu QuŽbec
Vendor
It automates alerting. I would like to see better support for Oracle GoldenGate.

What is most valuable?

The most valuable feature is the automation of the alerting. We can be proactive when we use that program instead of being called in the middle of the night because something’s wrong. You get the alert and the warning before. You can customize every threshold to meet your needs, and have different settings for different database groups.

How has it helped my organization?

The company spends less money over time because we are not working overtime hours at the office.

What needs improvement?

I would like to see better support for Oracle GoldenGate. Right now, it doesn't work well with Oracle GoldenGate. You still have to use GoldenGate monitor if you want to take advantage of the product.

There are some bugs and often we cannot debug the product right there and we have to reconfigure some things. It does the job, as long as you don't encounter a bug.

What do I think about the stability of the solution?

The stability's not so bad. It's a stable product, a mature product. When we change versions, there are some problems there.

What do I think about the scalability of the solution?

Scalability's good. We went from two databases to over 250. It's working fine.

How are customer service and technical support?

We have used technical support many times; it is very bad. We often had to dig down ourselves into the source code to find out why it’s not working on our platform. Every time we conferred about that, it became a little more complicated. Their answer is often to just delete the target, rediscover it and it should be fine.

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

We were pretty much doing our own thing with an in-house script. Since we were growing fast, we could not continue like that.

How was the initial setup?

Out of the box, initial setup is pretty straightforward: You install it, you discover your target and it monitors them. If you want to go further and do custom monitoring, for example, it can become quite complicated. On the other hand, it's very flexible. That's good.

Which other solutions did I evaluate?

It's been a long time, so I don't remember which other products we were considering. Probably from the beginning, we were considering Oracle because they let us experiment with it first and we saw that it worked. Also, because we kind of expect our versioning to follow the version of the database.

What other advice do I have?

Go only with the out-of-the-box configuration first. Let it run for a while like that to learn the product. Learn a few things before trying to configure everything in it.

When I’m selecting a vendor, price is a big factor. Licensing is a big factor. It has to do the job we need it for. Those are the most important criteria.

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
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.

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_user522240 - PeerSpot reviewer
Healthcare Operations Supervisor – Optum Health San Francisco at a healthcare company with 10,001+ employees
Real User
I can see the whole picture and analyze the data.

What is most valuable?

I can run the database, run queries, run reports, see the whole picture, and analyze the data.

How has it helped my organization?

I can see the whole picture and analyze the data; I rely on that a lot. I feel like I can see the whole entire database.

What needs improvement?

It could be faster; sometimes it takes a while to make the connection. Sometimes, it's complicated, too.

What do I think about the stability of the solution?

It is very stable. Once in a while, I see IT involved in a ticket but I don't think it happens all the time.

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

I think we used to use Sybase and then we transferred to Oracle. Now they no longer use the Sybase servers. I’m not so sure why we switched from Sybase to Oracle; maybe the technology made them move from Sybase to Oracle, maybe it was more stable, more space or something like that.

What other advice do I have?

I like it. I would encourage a colleague or friend looking for advice to use Oracle.

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.