Try our new research platform with insights from 80,000+ expert users
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.

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

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 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
it_user431829 - PeerSpot reviewer
Professional Services Manager at a tech services company with 501-1,000 employees
Consultant
The Lifecycle Management Pack has allowed the organization to have an almost real-time view of security and compliance across every single database within the estate.

What is most valuable?

Over and above the monitoring, alerting and incident framework, all of which are excellent, I would say the Lifecycle Management Pack is of most value to us.

How has it helped my organization?

For a particular client, they had a large database estate with over 750 databases and it wasn't actually possible to measure their compliance position against their own security standard at any given time. They had a view of a few systems, but the collection and aggregation of data was manual intensive and time consuming.

The Lifecycle Management Pack for Enterprise Manager has allowed the organization to have an almost real-time view of security and compliance across every single database within the estate. This was also based on their own internal security standard which has been created in Oracle Enterprise Manager via pre-packaged and customized compliance rules.

What needs improvement?

I think with the documentation there could be improvements. Although the core database compliance functionality is well documented some of the other areas of compliance aren't for example the Real Time monitoring rules. Also, further information on how compliance rule data is collected from repository to agent would be helpful and would assist when digging into the Oracle Enterprise Manager repository for building BI reports using BI Publisher.

For how long have I used the solution?

I've been using it for four years.

What was my experience with deployment of the solution?

Understanding how to build custom compliance rules was probably the area which took most time but that was still relatively simple. Also, while using the product this area was refined in 12.1.0.4 release with Agent Side rules, we started using this feature in 12.1.0.3 with Repository Side rules.

What do I think about the stability of the solution?

We have had no issues with the stability.

What do I think about the scalability of the solution?

There have been no issues scaling it.

How are customer service and technical support?

Customer Service:

Technical Support:

On the whole, technical support was good. Some of the very niche questions I had regarding some of the internal workings and collection of data took a little while longer to get answers for, but, to be fair, I always managed to find an answer to those queries.

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

For managing estate-wide security compliance, the only previous option was a scripted solution which was costly and not scaleable.

How was the initial setup?

Deployment of Oracle Enterprise Manager is straightforward as the documentation is good and the issues in deployment are rare. The challenge comes in ensuring that you configure all the relevant aspects of Enterprise Manager prior to rolling out agents and using the product in anger. This isn't necessarily an issue with the product, but rather the mindset of how sometimes it's deployed. I've assisted in a number of projects which was to retrospectively fix Oracle Enterprise Manager deployments.

What about the implementation team?

Having assisted on many Oracle Enterprise Managers implementations and seen the common mistakes, I wrote an article about it for the Oracle Scene Magazine Issue 57 (http://tinyurl.com/hxe4q9n). In summary, it's about planning what you want Oracle Enterprise Manager to do in helping you manage your IT estate and then undertaking the necessary configuration. Too often, people put little thought or effort into understanding what the product can do and just start rolling out management agents and then undertake a period of protracted reconfiguration.

What was our ROI?

Don't underestimate the time you invest in deploying and managing Oracle within your wider IT estate. The Lifecycle Management Pack needs to be seen as an essential purchase with Diagnostics and Tuning Packs. You may be able to create some 'home brew' solutions for software deployment, compliance and configuration management, but it will be light years behind what the LCMP can do and it's something that will continually be developed and improved.

What other advice do I have?

Oracle Enterprise Manager is an Enterprise Management tool and should be treated as such. It's not a glorified DB console. Companies should look to configure it in a way which takes away all the low-level, least value-add activities that DBAs have to do on a day-to-,day basis. As an organization look at the value the product could bring and deploy it as you would any other software asset.

Disclosure: My company has a business relationship with this vendor other than being a customer: We implement Oracle products for our clients.
PeerSpot user
Buyer's Guide
Oracle Enterprise Manager
January 2025
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
832,138 professionals have used our research since 2012.
Ashish Gaire - PeerSpot reviewer
Sr. Sun Solaris Field Support Consultant at World Distribution Nepal Pvt.Ltd
Reseller
Top 5
Stable monitoring tool that can help manage all the resources and view all the resources from a single dashboard
Pros and Cons
  • "The single-pane and single interface in the centralized system is the most valuable feature."
  • "There are limited numbers of other OEM devices that can be integrated into enterprise management that can be scaled by Oracle by adding other OEM devices to enterprise management."

What is our primary use case?

Enterprise Manager is a centralized system. It will help integrate all the Oracle servers and Oracle applications into a central single dashboard that we can see, and it helps to monitor and control all the services from enterprise management.

What is most valuable?

The single-pane and single interface in the centralized system is the most valuable feature. All the enterprise services can be seen from a single pane, whether it be a database, applications, or hardware. We can manage and monitor from a single page.

What needs improvement?

Lots of other OEMs we can integrate, but there are very few variants that we can bind and see and monitor from OEM Enterprise Manager. In that case, Oracle can increase the addition of other OEM devices that we can integrate into enterprise management.

There are limited numbers of other OEM devices that can be integrated into enterprise management that can be scaled by Oracle by adding other OEM devices to enterprise management.

For how long have I used the solution?

I have been working with this solution for more than five years. 

What do I think about the stability of the solution?

It is a stable solution. I would rate the stability a ten out of ten. 

What do I think about the scalability of the solution?

It is a scalable solution. I would rate the scalability a ten out of ten.

All the clients that have Oracle servers are using the Enterprise Manager. So, there are around six to seven clients using this solution.

How are customer service and support?

The customer service and support was very good.

How would you rate customer service and support?

Positive

How was the initial setup?

I would rate my experience with the initial setup an eight out of ten, with one being difficult and ten being easy. 

The deployment process takes five to six hours. 

What about the implementation team?

The process will take the deployment of our database first. We need to set up the Oracle database. After that, the database is created, and we need to create a listener. And after that, we can set up the Oracle Enterprise Manager database. In the middleware, it will communicate with the database, and after the process is complete, we can browse the Oracle Enterprise Manager. With the help of Oracle Enterprise Manager, we can communicate with all the servers and other posts that support SNMP or with whichever supports the Oracle Enterprise Manager point.

What other advice do I have?

It's a very stable monitoring tool that can help manage all the resources and view all the resources from a single dashboard.

Overall, I would rate the solution a nine out of ten. I deducted one point because it doesn't offer a feature of allowing other operating systems to be hosted on Spark.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
Subject Matter Expert at Cyprobes
Real User
Top 5
A data encryption tool that is easy to use but has a high price tag
Pros and Cons
  • "The solution is easy to use and has good performance."
  • "The tool is expensive."

What is our primary use case?

We use the solution for data encryption.

What is most valuable?

The solution is easy to use and has good performance.

What needs improvement?

The tool is expensive. 

For how long have I used the solution?

I have been using Oracle Enterprise Manager for ten years. 

What do I think about the stability of the solution?

I rate the solution’s stability a nine out of ten.

What do I think about the scalability of the solution?

The solution is scalable. The solution’s scalability depends on how you manage your hardware, server type, storage and the processes needed.

We have 200,000 users using the solution. We have sufficient usage of the solution.

How was the initial setup?

The initial setup of the solution is straightforward. The time of deployment depends on the database and customer. The solution needs a third-party integration that uses the database.

Deployment is the same with the wireless license. You first deployed a server to the cloud and then created a schema for all your data links. The deployment process depends on the system type you will implement.

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

The solution’s licence is expensive. It is a user-based solution and has a yearly subscription for upgrades.

What other advice do I have?

The maintenance of the Oracle Enterprise Manager solution depends on the type of banking system you are using, the number of users, the amount of data, and whether or not you have migrated any data. Since we have not migrated any data, it is going as it is.

You should go for an open-source solution if possible.

Overall, I rate the solution a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522081 - PeerSpot reviewer
Senior Application Manager at HDR inc
Vendor
We are able to track our engineers' time correctly. The methodology for pulling data together is complex.

What is most valuable?

It basically provides a transformation for the company to go into the product line application. It gives better and faster data to the management in order to review the data quickly.

How has it helped my organization?

Using this product, we have improved our process for generating revenue and sending out invoices to our customers. It also enables us to track our engineers' time correctly.

What needs improvement?

We are expecting new functionality in the billing aspect. In respect to the engineering sector, there is a need to include the performance part in the management side.

Still, there are lot of improvements that need to take place. For example, we are expecting basically a vertical solution for the engineering industry in terms of federal and department transportation solutions. We are expecting this in the product. Right now, there is no such type of product with which you can generate this solution.

What do I think about the stability of the solution?

This product is around 80 percent stable; 20 percent we are working on enhancing the product.

What do I think about the scalability of the solution?

I would rate the level of this product’s scalability at a 8/10.

It basically avails of a wide range of data, which it can pull together in one dashboard and present this data to the management in a quicker manner. This is the only scalable aspect in the product.

How are customer service and technical support?

We have used Oracle Advanced Customer Service and found them to be helpful. They supported our product.

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

We are transmitting from one ERP to another ERP, so the people need to be supported. Basically, Oracle advised us since it is the same product.

After which, we moved to EBS for future data support. They created a custom solution since we are unable to apply the patches or anything, so then we moved to this product.

How was the initial setup?

It is a complex product, in its methodology of how to pull the data together and then how to copy it. The other reason is the process as to how we need to send it to our customers, for timely invoicing without any backlogs.

What other advice do I have?

The reason why we chose this vendor is because they were familiar with the product now, and they gave a better judgement of the product itself.

Oracle is more flexible and you can convert it as per your business. That is why we have this solution. Whereas in other ERP products like SAP, we cannot customize the product and we need to use what exactly they provide.

We are going to see how it is helping the organization. That is the way we are going to do research.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
MajedAlzahrani - PeerSpot reviewer
Oracle database lead at Ministry of Energy
Real User
Top 5
Provides comprehensive monitoring and management, but the cost should be improved
Pros and Cons
  • "The best part is the efficient database performance monitoring and the ability to take actions directly from there."
  • "I would like to improve the cost."

What is our primary use case?

The best part is the efficient database performance monitoring and the ability to take actions directly from there. For example, if any issues arise, such as performance slowing down or sessions getting stuck, you no longer need to go to the server and write a script to address them.  

What is most valuable?

The best part is the efficient database performance monitoring and the ability to take actions directly from there. For example, if any issues arise, such as performance slowing down or sessions getting stuck, you no longer need to go to the server and write a script to address them.   

What needs improvement?

I would like to improve the cost. 

For how long have I used the solution?

I have been using this solution for the past three to four years. 

What do I think about the stability of the solution?

It is a stable solution.

What do I think about the scalability of the solution?

It is a scalable solution.

How are customer service and support?

We need two people for the deployment process. 

How was the initial setup?

The initial setup is straightforward.

What was our ROI?

The return on investment is good.

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

The license is good but can be improved. 

What other advice do I have?

Overall, I rate the solution a seven out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Oussama Bourguiga - PeerSpot reviewer
DevOps engineer at Esprit
Real User
Top 5
A scalable solution used for monitoring, but its stability could be improved
Pros and Cons
  • "Oracle Enterprise Manager is a scalable solution."
  • "The solution’s stability could be improved."

What is our primary use case?

We use Oracle Enterprise Manager for monitoring.

What is most valuable?

Oracle Enterprise Manager is a scalable solution.

What needs improvement?

The solution’s stability could be improved.

For how long have I used the solution?

I have been using Oracle Enterprise Manager for five months.

What do I think about the stability of the solution?

I rate Oracle Enterprise Manager a seven out of ten for stability.

What do I think about the scalability of the solution?

Oracle Enterprise Manager is a scalable solution. Many users are using the solution in our organization.

How are customer service and support?

I am satisfied with the solution's technical support and their response time.

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

I have previously worked with Grafana and Zoho.

How was the initial setup?

The solution’s initial setup is straightforward.

What about the implementation team?

We implemented the solution through a third-party vendor team.

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

Oracle Enterprise Manager has a yearly licensing fee, which I think is expensive.

What other advice do I have?

I would recommend Oracle Enterprise Manager to other users.

Overall, I rate Oracle Enterprise Manager 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
Akin Temel - PeerSpot reviewer
Database Manager at Gantek
Real User
Good graphical user interface and good monitoring but does not scale
Pros and Cons
  • "Due to the infrastructure's size, the introduction they offer is very, very useful. It helps with an overall understanding of the product."
  • "The solution has a very large resource system. It's too big. There are too many items."

What is most valuable?

The solution's most valuable aspect is the fact that it is embedded with the Oracle database and Oracle's engineering system, its extra data, and analytics. 

They have plug-ins that are very helpful. 

Due to the infrastructure's size, the introduction they offer is very, very useful. It helps with an overall understanding of the product.

They have a very nice graphical user interface.

The monitoring is good.

We can capture the SQL tune from us. With Oracle Enterprise Managers, we can see the rich performance tuning. 

What needs improvement?

Oracle has made a pretty complex system, which has made us want to explore other options.

The solution has a very large resource system. It's too big. There are too many items.

The solution has too many licenses. If you want to monitor the MSS or the other tasks, they want you to use their license. However, it's a very expensive license. Oracle is a very big company. The database is the number one product in Oracle, and in the world. They don't need to charge for the adjusted monitoring tool. They already are making so much on licensing elsewhere. I don't like it.

The initial setup is rather difficult.

It would be ideal if Oracle offered something that was open-source. They don't yet offer an open-source database. We would like to have the freedom to monitor in-house.

The solution does not scale at all.

For how long have I used the solution?

I've been using the solution for about five or six years at this point. It's been a while so far.

What do I think about the stability of the solution?

It's a stable product. For the most part, they have quite a stable system. However, there are at times difficulties with the project server. They have a very big container program in their project server as Enterprise Manager is running in the project server. The old configuration was more difficult, and, in any case, users need to be precise with their configurations to ensure stability.

What do I think about the scalability of the solution?

The solution is not scalable at all. You would not choose this solution in order to expand on it later.

How are customer service and technical support?

I can't say that I have experience with technical support. I cannot comment on it.

How was the initial setup?

The initial setup is not straightforward. It's quite complex, or, rather, not very easy. You really have to concentrate on the tasks. You must first install the database before we can use our SQL server or our SQL database. Now, you must do the record database first. You must install the database before the server. I don't understand why. Then, you have to try to install the Enterprise Cloud Control Manager. 

It's important that whoever installs the solution has specific Oracle knowledge, otherwise they will run into problems.

What other advice do I have?

We are partners with Oracle. We have a business relationship with the company.

I have more than 20 years in the IT sector. I am a database engineer.

We tend to use the latest version of the solution, however, we have clients on older versions. We have one client, for example, on version 12.

I would rate the solution at a seven out of ten, overall. We're mostly satisfied with the product.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros sharing their opinions.
Updated: January 2025
Buyer's Guide
Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros sharing their opinions.