Try our new research platform with insights from 80,000+ expert users
it_user522186 - PeerSpot reviewer
Database Engineer at a comms service provider with 10,001+ employees
Real User
It is easy for the novice DBA to drill down and find problems that might otherwise be difficult to find.

What is most valuable?

The most valuable feature is that it is very easy for the novice DBA to drill down and find problems that might otherwise be difficult to find.

How has it helped my organization?

It has helped developers and novice DBAs drill down and find the cause for problems. There are two pieces. One, it allows people to pinpoint issues easily, and then drill down and get more details of the issue. Previously, this used to be a skillset in the hands of a very few people, but now virtually anybody can do it. Even if they can't fix the actual problem, they could filter down a lot of the issues, and get only the relevant information, which is helping us.

What needs improvement?

I probably would like to see better SQL tuning advisors that are built into the product. When you know the issue, rather than just pinpoint it, if it could also give you a solution that might work, I think that would help the product.

There are a few things on the wish list. We would hope that it makes some predictions of what we could fix and also the resources for printing that it takes. In some cases, it is not available when we need it the most.

What do I think about the stability of the solution?

It is mostly stable, but we have found some issues when we are having resource contention or CPU issues. It is not easy to bring up the product because it is a bit of a resource hog. Sometimes when you need it the most, that is when you find it missing, but those are rare and far between.

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

What do I think about the scalability of the solution?

It is a very scalable product. No complaints there. We use it for hundreds of databases and it grows.

How are customer service and support?

On a scale of 1 to 10, I would probably give Oracle tech support somewhere between a 6 and a 7. Often, when you know what the issue is, there is a lot of collecting data for root cause which we might have provided just the previous day. We find ramp up is a bit of a waste of time before we can actually get a solution.

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

We were covered by the Oracle enterprise license agreement and it made more sense for us to go with this product as opposed to looking for another one. They have had it for a very long time.

How was the initial setup?

It is a very straightforward setup and also we had help from Oracle as part of our enterprise license agreement with my company. They helped set it up and it has been working pretty well.

Which other solutions did I evaluate?

It was an easy choice. The Oracle Enterprise Manager is pretty well known and I don't think anything else, an external product, matches or comes even close.

What other advice do I have?

Look at the reputation and the size of the company. These products are often very expensive. It is better to go with someone who has been around for a long time and who would continue to be in business, as opposed to flavor-of-the-month products.

When I am looking at a vendor such as Oracle, the most important criteria that I am looking for from them are market reputation, the scale of the company, and the stability.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user488784 - PeerSpot reviewer
System Architect at a consumer goods company with 10,001+ employees
Real User
It reduces overall required downtime. Better stability is required.

What is most valuable?

Both OS and Hardware Management, Network Boot, Server Pools, and Live migration of LDOMs over Server Pool are Ops Center's most valuable features to me.

How has it helped my organization?

It helps a lot in data center consolidation, P2V, and with LDOM live migration. It reduces overall required downtime and is highly scalable, especially with T5 architecture.

What needs improvement?

The monitoring feature should be improved, so that it may be used as a dependable monitoring solution, as well as a deployment solution for SPARC-based hardware and operating systems.

For how long have I used the solution?

I have used the product for three years.

What was my experience with deployment of the solution?

No, I didn’t encounter any issues with deployment, stability or scalability.

How are customer service and technical support?

I will rate technical support at 9.

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

I have had the opportunity to work with various other UNIX as well as Linux systems, but among all of them, I found Solaris to be a very stable operating system. Now with the evolution of LDOMs, ZFS and zones, it’s providing a perfect platform for virtualization solutions.

How was the initial setup?

To me installation doesn’t seem complex, but at the same time comprehensive understanding of technology is required.

What about the implementation team?

We performed implementation ourselves, except some time when we requested Oracle’s professional services.

What other advice do I have?

I recommend Oracle solutions like T5 Super-Cluster, T5-8 and Oracle Solaris 11 operating systems, as they are highly scalable and fault-tolerant systems.

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
December 2024
Learn what your peers think about Oracle Enterprise Manager. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
it_user90537 - PeerSpot reviewer
Database Manager at a energy/utilities company with 501-1,000 employees
Vendor
Valuable reporting and tuning features. Improved my companies central reporting and management tool for Oracle database

What is most valuable?

Reporting and tuning

How has it helped my organization?

Central reporting and management tool for Oracle database and middle-tier products

What needs improvement?

BI Publisher integration; EM CLI commands

For how long have I used the solution?

Four years

What was my experience with deployment of the solution?

Agent deployments are easy

What do I think about the stability of the solution?

Not with 12c OEM

What do I think about the scalability of the solution?

No

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

Home-built shell scripts required maintenance, incurred higher overhead, and exposed the company to risk if a key employee left

How was the initial setup?

Initial installation of 12c OEM is convenient and straightforward

What about the implementation team?

In-house implementation

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

OEM required 1.5 full-time employees during setup and still requires that much support in production

Which other solutions did I evaluate?

No

What other advice do I have?

There are several sources of information including IOUG and communities.oracle.com
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Commercial Manager at Natco Information technology
Real User
High availability and useful features for partitioning with fast responding technical support
Pros and Cons
  • "The most valuable feature is high availability."
  • "RMAN tools need improvement."

What is our primary use case?

The primary use case of this solution is used in our HSA Group for backup and recovery.

What is most valuable?

The most valuable feature is high availability.

The features that we are using the most are for partitioning, Armonk, and encryption. 

What needs improvement?

RMAN tools need improvement.

There are some doubts about the Oracle policy on price quotes. I have a good relationship with the customers and If I start dealing with them, and get them a discount, then that discount is available to all of the Oracle partners. I prefer the way it works with other companies, like HP, where any discount that I negotiate on behalf of a customer will be available only to me.

For how long have I used the solution?

I have been using this solution for twenty-five years.

What do I think about the stability of the solution?

This solution is stable, and it's reliable.

What do I think about the scalability of the solution?

This solution is scalable.

How are customer service and technical support?

Technical support responds quickly. Our customers are satisfied with the availability of technical support.

How was the initial setup?

The initial setup is straightforward. I have been a DBA for ten years now and I have been working with Oracle for twenty-five years.

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

The pricing is very high.

What other advice do I have?

This solution is the best! It's perfect!

I would rate this solution a ten out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
PeerSpot user
Team Lead, Database Administration at a financial services firm with 10,001+ employees
Real User
Wait-events can be viewed and investigated in real-time, making resolution easier
Pros and Cons
  • "Some of the most valuable features are its real-time performance view/dashboard, metric history, real-time monitoring and alerts, as well as quick access to Oracle's tuning and diagnostic options."
  • "I feel more dashboards can be added, especially those useful to higher levels of IT management."

What is most valuable?

Some of the most valuable features are its real-time performance view/dashboard, metric history, real-time monitoring and alerts, as well as quick access to Oracle's tuning and diagnostic options.

These are valuable because it makes it much easier to investigate periods in the past (good or bad) as metrics for a period are stored in the repository. Real-time resolution of issues is made easier as wait-events can be viewed and investigated in real-time. SQL queries can also be viewed and investigated in real-time and recommendations are available if the diagnostic and tuning packs are licensed (Oracle databases).

In my experience it seems the best tool for monitoring Oracle products, ranging from software to hardware like the engineered systems (e.g. Exadata).

How has it helped my organization?

In my team, we have display screens dedicated to displaying the real-time wait-events of our most critical databases. Every team member can look up and tell the average health of the critical Oracle databases at a glance. If something unusual is going on, it is immediately apparent on the display.

In addition, Oracle Enterprise Manager completely and adequately handles our hardware and software alerts which are sent out by email as soon as set thresholds have been exceeded.

What needs improvement?

I feel more dashboards can be added, especially those useful to higher levels of IT management.

I feel it would be great to have improved support for other database types like MySQL and Microsoft SQL Server.

I also think additional software like the JAgent for monitoring GoldenGate installations should be integrated into Oracle Enterprise Manager itself, and not require additional installation and configuration.

For how long have I used the solution?

About four years.

What do I think about the stability of the solution?

Generally, it is pretty stable. Occasionally, one may run into errors that may be tricky to resolve without in-depth knowledge of the product or the help of Oracle Support.

What do I think about the scalability of the solution?

No, I haven't had any issues with scalability so far.

How are customer service and technical support?

On a scale of one to 10, eight.

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

We previously used Dell Spotlight, but needed more in-depth administration and monitoring capabilities, as well as a web interface.

How was the initial setup?

Initial setup was pretty straightforward. Most administrators with some experience in installing Oracle applications and databases shouldn't have a problem setting it up, as long as they follow the installation guide.

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

As with all Oracle products, care should be taken when using any features to ensure that they do not activate licensed features that have not been paid for. Oracle Enterprise Manager allows one to do so many things easily, but it is up to the administrator to be sure of the licensing implications.

Which other solutions did I evaluate?

Dell Spotlight was the only other option we looked into before settling on this product.

What other advice do I have?

Oracle Enterprise Manager is great for monitoring and administering Oracle hardware and software. However, administrators should ensure that their actions are limited to free and licensed features only, otherwise there may be trouble at the next Oracle license review.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522192 - PeerSpot reviewer
Oracle Database Architect at a computer software company with 501-1,000 employees
Vendor
We use it to monitor sites without scripting, maintain all databases in one place, and standardize code.

What is most valuable?

It's a standardized GUI tool, which is very good and pluggable with automatic connection to an Oracle database, in comparison with any other GUI tools available in the market. Other than that, if you see if you want to share the backups, or if you want to do any monitoring stuff, to customize your monitoring, and if you want to do the blackout. If you are doing any amendments, you can do a blackout.

If you want to monitor the regular site without doing any scripting or anything, you just need to plug in both databases, and then it's easy to maintain. It's one tool to maintain all the databases in one place without doing much customization, and it's easy to manage.

How has it helped my organization?

People used to say I develop my own scripts, or colleagues used to develop their own scripts. If you want to change, if you are doing an upgrade, or if you are going to migrate your database, for example, from Linux to Solaris (REAX), then we need to change all this coding, right, to support that. I want to write my own code, and he wants to write his own code. Everybody out there wants standards to write the code. Then when you do migrate all these things, we need to do so much hard work to make it actually work. If you use OEM as a standardized tool, then it's easy to manage, and you don't need to do all this hard work, which it makes easy.

What needs improvement?

If you see the documentation, it's not really that much good. They did not explain all the details, so maybe they need to improve the documentation to get a better understanding, so that most of the people can use it.

What do I think about the stability of the solution?

Stability is good, but I can see only very small performance issues. When the system is very busy and I click a report, sometimes takes a little bit more time than I expected. If you fix those performance issues and best practices, I think it's an awesome tool.

What do I think about the scalability of the solution?

I was able to scale with multiple margins: small, medium, large, and extra large. We can pick those according to your organization’s size.

How is customer service and technical support?

Technical support is always good. The only thing we need is to create a right severity, and talk to the right folks, actually. Then problems will be resolved.

Which other solutions did I evaluate?

I checked the BMC Patrol and Quest products also, to monitor the databases. I feel like among all these, that OEM is the best tool compared to any other.

What other advice do I have?

I feel that it's a good tool. The only thing is that you need to read the documentation before starting anything. As you mentioned about the size, you need to know how may databases you want to monitor in the company, and pick the right size.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user521577 - PeerSpot reviewer
Sr. IT Professional and Database Expert at a manufacturing company with 10,001+ employees
Real User
You can check your SQL executions and how the SQLs are progressing in terms of any blocks or contention in the database.

What is most valuable?

You can monitor your database thoroughly. Some valuable features of this product are checking your SQL executions and how the SQLs are progressing in terms of any blocks or contention in the database. In other words, you can monitor the entire progress of your database per millisecond.

How has it helped my organization?

It benefits our organization by identifying the problem immediately and rectifying it. So, the user doesn't have to bear any sort of impact.

What needs improvement?

Some of the features that need improvement are increased monitoring at the operating system and storage levels, without having a plugin. At the Oracle level, improvements can be done by providing minute details in regards to SQLs.

What do I think about the stability of the solution?

The product is stable 99.9% of the time, but there are a few issues that need to be improved. I have noted that these issues are generally updated in a later version of the product, as and when it is released.

What do I think about the scalability of the solution?

Oracle does provide some plugins. However, if these can be provided with the Oracle Enterprise Manager software itself, there is a scope for scalability. In addition, increased monitoring at the storage level and the OS level can really help.

How are customer service and technical support?

The technical support is not always 100% up to the mark or sometimes not as we expect it to be.

At times, they (the customer support team) take more time to respond or we don't get the desired response/solution from their end and then we have to keep tracking them.

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

We have always been using this product.

How was the initial setup?

The setup is simple and not complex. I find that it has improved with later versions that are being released.

The setup process used to take much longer than it does now and I hope that this will be enhanced in the future.

Which other solutions did I evaluate?

We have not evaluated any other product besides Oracle, as it suits our product best.

What other advice do I have?

Stability and responsiveness are the two major factors while choosing a product. Right now, response time is the most critical aspect for our organization and that is what we need.

If you database scalability is more or if your infrastructure is as big as the product we have, Oracle is the only solution out there. There are other competitors, but they are all NoSQL database tools. Thus, Oracle stands out.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user436107 - PeerSpot reviewer
Sr DBA at a energy/utilities company with 1,001-5,000 employees
Vendor
I can drill down to the user level or the SQL level and see what was happening at any point in time. The UI is not good and is still pretty ugly.

Valuable Features

I like the performance tuning features, particularly since it gives me a good glimpse of what has been happening. We maintain the data for 31 days, so I can graphically go back and see what exactly happened during that time. I can drill down to the user level or the SQL level and see what was happening at any point in time. That's a pretty good feature, and because it's more graphical, I don't have to analyze a whole bunch of rows.

Improvements to My Organization

In terms of the user response time, if I were to do a lot of queries, and analyze it, we can quickly provide the result to the end user or the developers, and then quickly come back to solving a lot of performance problems.

Room for Improvement

With any Oracle protocol, and Enterprise Manager is one of them, as far as the interface is concerned, it's not good and is still pretty ugly. I would like to see a decent UI because there are a lot of tools on the market that also give good drill-down capabilities. For example, with Enterprise Manager's drill down to database blocking logs, you can no longer see that in the UI, whereas other tools allow that. I need to be able to do this type of drill-down in one tool without having to manage different tools that do different things.

Use of Solution

I've been using Oracle products for 22 years.

Deployment Issues

We've had no issues with deployment.

Stability Issues

You should go with the latest version as it's more stable, and that's one of the reasons I like it. It's a pretty stable platform.

Scalability Issues

We have a pretty good number of database with Oracle Enterprise Manager. You can scale it as much as you want. We have about 1,200 databases that we manage using it.

Customer Service and Technical Support

I have not used technical support because I am not the one who administer it. Technical support is good, I've heard.

Other Advice

If you're using one or two databases, Enterprise Manager is not something you want to use because Oracle has other products that can make it simpler. But ff you are using more than five or six databases, Enterprise Manager is the way to go.

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