it_user1017 - PeerSpot reviewer
eCommerce Expert at a computer software company with 501-1,000 employees
Vendor
It is about best service levels for traditional and cloud applications through business-driven application management.

What is most valuable?

• Enterprise Manager 12c comes with an out-of-box self-service application that lets end-users deploy a wide range of these services. End users can choose to manage and monitor all applications along with databases and platforms/OS, all in an on-demand fashion. For each request, they can specify the amount of underlying resources (CPU, memory, etc.) that they require for each component. • Enterprise Manager automatically provisions the requested service and the appropriate resources. The self-service application also lets users define policies to scale out or scale back resources based on schedule or performance metrics. For example, one can set a policy to elastically scale out a web server if the processor load on existing web servers exceeds a certain threshold value. • It allows management of sophisticated Oracle applications, like Oracle E-Business, Siebel, and PeopleSoft, aiding in many administrative activities of these apps, like real user monitoring of any web application.• Enterprise Manager 12c has the ability to define contractual Service Level Agreements (SLAs) that govern the contract between the application owner and the provider of the Cloud. Administrators, as well as users, can also define management policies that automatically adjust the service resources, to ensure that SLAs are met.• Enterprise Manager enables the application for the end-user via a self-service interface, both in graphical (GUI) .

What needs improvement?

The only con is that we may need to install patches provided by Oracle from time to time for its upgrades or bug fixes. This is an activity that occurs quite frequently.

What other advice do I have?

Oracle Enterprise Manager 12c, is a transformational technology that comes with a set of comprehensive features and great practices, that help IT transform into a true enterprise Cloud that delivers on business needs. It offers a single integrated console for testing, deploying, operating, monitoring, diagnosing, and troubleshooting, today’s complex and wide IT environments. It offers a simple scalable solution for running Oracle applications. It enables you to manage everything in your datacenter, from the hypervisor to the operating system, database, and application tier. I have used this technology for quite a long time and found that Oracle Enterprise Manager is the industry’s first solution that has the ability model, not only infrastructure as- a-service (IaaS), but also platform-as-a-service and database-as-a-service Clouds, from a single console. The extent of usage of Oracle Enterprise Manager depends upon nature & the size of the organization and management’s concerns. However, Oracle Enterprise Manager provides a full board of controlling & monitoring as per your needs.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user1017 - PeerSpot reviewer
it_user1017eCommerce Expert at a computer software company with 501-1,000 employees
Vendor

it was suppose to be an overview with pros and cons of the product. Comprehensive functionality comes under USER MANUAL and this is not a user manual.

See all 2 comments
it_user522057 - PeerSpot reviewer
DBA at a pharma/biotech company with 1,001-5,000 employees
Vendor
Monitors all our Oracle infrastructure and as a DBA I also use it for SQL monitoring
Pros and Cons
  • "It's user friendly."

    What is our primary use case?

    We primarily using this for the monitoring, it monitors all our Oracle infrastructure. As a DBA I also use it for SQL monitoring and for performance tuning analysis.

    What is most valuable?

    It's user friendly.

    How has it helped my organization?

    We have Oracle Accelerator. We heard this is a better tool for monitoring Accelerator. But it's more than monitoring just that, we have extended the monitoring to DB2 and SQL Server platforms.

    What needs improvement?

    I think they have already listed some things in 13c. I heard it includes a couple of features we are looking for like monitoring templates. I want to explore those features. Probably they will be included in 13c.

    For how long have I used the solution?

    We have been using it for the last three years.

    What do I think about the stability of the solution?

    It is pretty stable. There are some pros and cons, but we compared it to other tools which are available for monitoring Oracle databases and other products, and what we found is this is one of the best.

    What do I think about the scalability of the solution?

    It's scalable. Currently, we are monitoring close to 3000 targets and it's pretty well scalable.

    How is customer service and technical support?

    I'm a bit skeptical of it. I personally experienced a little longer time than I would like to get the right solution for issues. They have good support. It depends on the person with whom you are interacting.

    How was the initial setup?

    I would say setup is moderate, actually. It's not that difficult. If you have a good background in web logic and servers then I think it's easy. They have very good documentation in place so you just have to follow the documentation and it can be installed easily.

    What other advice do I have?

    This is one of the best tools we've had. I would advise others to go for 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
    May 2024
    Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: May 2024.
    771,170 professionals have used our research since 2012.
    it_user522108 - PeerSpot reviewer
    Senior Client Partner at a tech services company with 10,001+ employees
    Consultant
    It is web-based. You can access it from anywhere. Access to taxation data would be great.

    What is most valuable?

    The most valuable feature is that it is web-based. That helps us to get access from any location without being dependent on your personal laptop. You can access it from any laptop, any iPad or even iPhone; kind of everywhere.

    How has it helped my organization?

    Access to the data; you can access it anywhere. That helps us to get the information readily. That improves productivity as well.

    What needs improvement?

    Some of the new features it could give us: maybe access to some of the taxation data and also some of the other benefits it could include as part of the system. That would be useful.

    What do I think about the stability of the solution?

    My experience with the stability has been very good. I have not seen any issues. I use it for my own purposes, in a limited way, but I haven't come across any instability or not being able to access the data; it being down or anything like that.

    What do I think about the scalability of the solution?

    We’re using it for around 15,000 employees, and it is meeting our requirements. I’m not sure how much it can go up to, but at least 15-20,000, I have not seen any problem.

    How are customer service and technical support?

    I haven’t used technical support.

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

    They wanted something that was available everywhere instead of being available only on a particular laptop or PC. That was one of the reasons for it: easy accessibility.

    The first reason we chose Oracle was the feature set; it was really comprehensive. Plus, it met most of our immediate needs. That kind of led us to pick Oracle.

    When I’m looking at a vendor like Oracle, the most important factors are stability, scalability, and of course, the price. All three of them definitely help to make a decision.

    How was the initial setup?

    Initial setup was really simple: just go to the website, register, and you’re good to go.

    What other advice do I have?

    If you are looking for a solution that is accessible, because of the global nature of the workforce, I think this is a good solution.

    From the features perspective, I see there's still more that could be done, as I have mentioned.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user521916 - PeerSpot reviewer
    IT Manager at a tech vendor with 1,001-5,000 employees
    Real User
    The graphical interface makes it handy to monitor the databases. Because of stability issues, we didn't roll it out into production.

    What is most valuable?

    I think what I really like in this product is that DBAs and my management development team don’t have to sit and manually write queries.

    It has a graphical interface, which makes it handy for you to monitor the databases and that is the most useful feature.

    How has it helped my organization?

    You can manage many databases at the same time.

    You don't have to write ad-hoc queries. Initially, my DBAs used to write scripts which were manual. So, running the scripts, writing them and trying to figure out what we want to monitor was a very difficult process. With OEM, you have all of this in the inbuilt interface, which really helped them in adding new databases in the main that we must monitor.

    As the number of databases increased, it was fast for us to start monitoring them as well.

    What needs improvement?

    One of the big problems we had was using Data Guard along with OEM; it just didn’t work (Data Guard is a local higher level solution). Every time we did a takeover, it would stop working, so that was the biggest challenge we had. I think that this has been probably fixed in Oracle Enterprise Manager Cloud Control 13c.

    We had issues in terms of stability. Some of the functionalities, which we were looking for, were not available. It's not that it wasn't working, but it wasn't able to meet all our requirements.

    What do I think about the stability of the solution?

    Stability, as far as it was in a test environment, we did find a few issues. This was in Oracle Database 11g and it would just hang our systems. Thus, we didn't let it go to production.

    How are customer service and technical support?

    We have Oracle Advanced Customer Support in our company. Using it was easy. It's just that product had a few issues in certain scenarios.

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

    Oracle recommended it to us: "Everybody is using it out there, so use it!"

    How was the initial setup?

    It was straightforward. We had to install a server on the database side and GUI on the client side; it was quite straightforward.

    What other advice do I have?

    Based on our experience, if you are looking for a certain type of requirement, it would work.

    The main requirement for us was stability since we run machine-critical applications.

    Resiliency is really the main requirement from our side, even beyond scalability.

    We run a company that provides services for banks and financial institutions, and resiliency is the most important factor, especially for a product like OEM. Security is equally important but for OEM, we don't really expose anything, so it's fine. It's more of a monitoring interface.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user436146 - PeerSpot reviewer
    President at a tech consulting company with 51-200 employees
    Consultant
    The agents for setup makes it easier to monitor databases as well as servers and SANs. Using, setting up, and maintaining the agents can be tedious.

    Valuable Features:

    Enterprise Manager comes with a suite of products that includes agents for setup. This makes it easier to monitor databases as well as servers and SANs.

    Improvements to My Organization:

    It's given us the ability to monitor multiple aspects of the organization. Also, the ability to monitor different versions of Oracle and different platforms has been helpful for our customers.

    Room for Improvement:

    Using, setting up, and maintaining the agents can be tedious and even almost a full-time job. Once it's done, it works pretty well. It's just setting them up that could use some improvements.

    Deployment Issues:

    We haven't had any issues with the deployment other than setting up the agents.

    Stability Issues:

    I've had problems with its reliability and speed. Sometimes even giving it a large amounts of software and hardware to run on, it can still be sluggish and fail to respond as quickly as you would think.

    Scalability Issues:

    It does seem to scale. Even when we throw thousands of objects at it, the scalability still seems to be there.

    Initial Setup:

    The newer versions are much simpler and they have a better look and feel, and once you get the agents taken care of, it goes a lot quicker.

    Implementation Team:

    We implemented it ourselves.

    Other Advice:

    If you are going to be database-heavy, and that is what you are going to be monitoring the most, then Enterprise Manager might be your best bet. If not, there are other options out there to look at to see which pieces you need to monitor. Do we need to monitor applications, servers, and networks? Figure out which part you're going to need for that.

    Disclosure: My company has a business relationship with this vendor other than being a customer: We're partners.
    PeerSpot user
    it_user101799 - PeerSpot reviewer
    Sr. Oracle, MySQL and Teradata DBA at a tech vendor with 51-200 employees
    Vendor
    We have found that OEM has improved significantly the monitoring and tuning of our databases

    What is most valuable?

    Monitoring and tuning of Oracle databases.

    How has it helped my organization?

    It has improved significantly our monitoring and tuning of our databases.

    What needs improvement?

    Installation and configuration.

    For how long have I used the solution?

    6+ years

    What was my experience with deployment of the solution?

    Yes, configuration is a pain.

    What do I think about the stability of the solution?

    Nope

    What do I think about the scalability of the solution?

    Nope

    How are customer service and technical support?

    Customer Service: 4 stars, sometimes support takes time to figure out the issue and provide a solution.Technical Support: 4 stars

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

    Used to monitor manually before.

    How was the initial setup?

    Medium difficulty

    What about the implementation team?

    In-house

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

    None

    Which other solutions did I evaluate?

    None

    What other advice do I have?

    Go for it and utilize all the features!
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user2652 - PeerSpot reviewer
    it_user2652Project Manager at a non-tech company with 10,001+ employees
    PopularVendor

    You marked technical support as 4. Can you please share an example where you had a delayed response or difficulty in getting support from Oracle?

    See all 2 comments
    it_user521574 - PeerSpot reviewer
    Bhavinee Patel at Apple
    Real User
    The GUI is user friendly. We can see the monitoring tools for the host or database.

    Valuable Features

    The most valuable feature is the user-friendly GUI. With OEM, we can see the monitoring tools for the host or database.

    Improvements to My Organization

    We use it every day. For any performance issue, we jump into OEM and then we use it. We monitor the database to help us deal with the issue.

    Room for Improvement

    There as some monitoring tools, such as GoldenGate, that would be great if they could put them in OEM.

    Right now, whatever we have is enough, but for additional features we want GoldenGate.

    Use of Solution

    We have been using Oracle for a long time.

    We do have other technologies.

    Stability Issues

    It's stable.

    Scalability Issues

    We are moving to a data center right now. It was in one data center and we are moving it to another data center, where we have our other data business, and it has scaled well.

    Customer Service and Technical Support

    Technical support is good; very good. They were efficient.

    Initial Setup

    Initial setup and upgrades were straightforward. We have upgraded from 10 to 11 and from 11 to 12.

    Other Advice

    It's a very flexible, straightforward installation. It's user friendly, usable day by day and we can see the database monitoring, host monitoring, everything.

    When I’m looking at a vendor such as Oracle, I look for good tech support, reliability, and stability.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Gerente da Unidade de Negocio Oracle at a tech services company with 11-50 employees
    Real User
    Streamlines diagnosis of database issues, has tuning capabilities for most issues found
    Pros and Cons
    • "With ASH Analytics, ADDM, Real-Time SQL Monitoring, SQL Tuning Advisor, we can measure SLAs, detect performance hotspots, perform deep diagnostics into specific tiers, tune applications, and remediate."
    • "It can also help with capacity planning, sizing, and maximizing overall performance in a large scale environment."

      What is our primary use case?

      We use Oracle Enterprise Manager primarily for database management, with a focus on performance monitoring. 

      Our environments are composed of both standalone and cluster databases which, in turn, are deployed in Oracle appliances like ODA and Exadata, as well as others hardware vendors.

      In addition, we use the tool to create, configure and manage high-availability environments using Oracle Data Guard and Real Application Clusters, automation of manual activities and patching.

      How has it helped my organization?

      With Enterprise Manager, we have achieved a dramatic decrease in the number of database incidents. As a result, unplanned downtime has been reduced because we are resolving issues before the business is even aware of them.

      What is most valuable?

      The product has powerful features for diagnosis of database issues, complemented with tuning capabilities for most of the issues found.

      With ASH Analytics, ADDM, Real-Time SQL Monitoring, SQL Tuning Advisor, we can measure SLAs, detect performance hotspots, perform deep diagnostics into specific tiers, tune applications, and remediate.

      What needs improvement?

      Oracle is always making improvements to Oracle Enterprise Manager. I think Enterprise cloud integration presents new management challenges.

      For how long have I used the solution?

      More than five years.

      What do I think about the stability of the solution?

      We always strive to have the latest version of this product, which has always helped to improve stability and performance.

      What do I think about the scalability of the solution?

      Yes, we encountered scalability issues. However, there are several techniques for achieving optimal performance. It can also help with capacity planning, sizing, and maximizing overall performance in a large scale environment.

      Inadequately-sized Enterprise Manager deployments may result in the overall benefits of Enterprise Manager being compromised.

      How is customer service and technical support?

      Good.

      How was the initial setup?

      The initial setup is pretty straightforward. Today, you can even download the templates found on the Oracle website.

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

      The basic functions are free. You only pay license fees for advanced features.

      Which other solutions did I evaluate?

      I’ve been using this product for years. I evaluated other options from different vendors such as Foglight and SolarWinds, to name a couple.

      What other advice do I have?

      To me this is the best product for enterprise database management. I rate it a 10 out of 10.

      Now, before you implement, you can do several tests with the Enterprise Manager templates VMS, available from Oracle. Also, check the compatibility matrix and try to always keep your system up to date.

      Disclosure: My company has a business relationship with this vendor other than being a customer: Platinum 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: May 2024
      Buyer's Guide
      Download our free Oracle Enterprise Manager Report and get advice and tips from experienced pros sharing their opinions.