it_user436065 - PeerSpot reviewer
IT Director at a tech services company with 51-200 employees
Consultant
It makes it very easy for us to manage our infrastructure.

What is most valuable?

I think the fact that I can manage all of our infrastructure, all the hardware and software, from one place which makes it very useful.

How has it helped my organization?

It makes it very easy for us to manage our infrastructure so that's important from a company perspective.

What needs improvement?

It's very expensive.

What do I think about the stability of the solution?

I think it's fine, there's no issue there.

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,862 professionals have used our research since 2012.

What do I think about the scalability of the solution?

I think it's fine, there's no issue there.

How was the initial setup?

It's implemented just fine. It's fairly easy. Combination of an easy product and also technical expertise as well.

What other advice do I have?

It's very expensive.

Disclosure: My company has a business relationship with this vendor other than being a customer: We're partners.
PeerSpot user
it_user436104 - PeerSpot reviewer
Data Modeler at a financial services firm with 1,001-5,000 employees
Vendor
The most valuable feature is the ability to manage all the databases, hardware, and middleware from one pane of glass.

Valuable Features

From my experience, I'd say that the most valuable feature is the ability to manage all the databases, hardware, and middleware from one pane of glass.

Improvements to My Organization

Having the single-pane-of-glass manageability of our database, hardware, and middleware infrastructure gives us the most efficient way to keep our thumb on the pulse of the infrastructure to ensure it's always up and running.

Room for Improvement

OEM needs to be a little bit faster. That's probably because the features that they've developed and put into the latest product are incredible. They're consolidating more and more, which, expectedly, slows it down.

Use of Solution

I've been using Oracle Enterprise Manager for the last eight to ten years.

Deployment Issues

We've had no issues deploying it.

Stability Issues

At the beginning it was in the development phase, but for the last, probably six years, it's been a fairly solid product from 10g right through to the current 12c version.

Scalability Issues

I haven't really had to scale it because the enterprise isn't large enough to require that, but the initial installation is sufficient for all the needs.

Customer Service and Technical Support

I've always been very happy with Oracle support. I think probably the one thing that I'd like to be able to have more of is input into the feature set for the next release.

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,862 professionals have used our research since 2012.
it_user100476 - PeerSpot reviewer
MySQL DBA at a tech vendor with 501-1,000 employees
Vendor
It's easy to find blocking or locking queries, to kill queries, and to explore table structure.

What is most valuable?

Query tuning, historical graphs, real time statistics on query usage, easy to find blocking or locking queries, easy to kill queries, easy to add new datafiles to tablespaces about to run out of space, easy to explore table structure

How has it helped my organization?

For Oracle databases we setup e-mail alerts through OEM. Setup several maintenance jobs to handle previously time consuming tasks such as automatically adding datafiles to a tablespace about to run out of space. Improved root cause analysis on database slowness issues

What needs improvement?

For databases and servers with high blocking issues, the monitoring and graphs in OEM frequently became so over loaded that they could not be used and would not load making OEM useless for troubleshooting certain production issues. When this would happen, I had to go back to using queries from the sqlplus command line.

For how long have I used the solution?

2 years

What do I think about the stability of the solution?

OEM agents on database servers frequently stopped collecting data and had to be restarted.

What do I think about the scalability of the solution?

Unknown, wasn't involved much with scalability but the Enterprise Manager web based site did get a little slower as we added thousands of servers.

How are customer service and technical support?

Oracle support is helpful and knowledgeable.

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

Used Toad a little bit but didn't have a solution exactly like EM. Toad licensees were expensive and had to be installed on each user's machine while enterprise manager was web based and I'm sure Oracle gave the company special pricing since we already used so many of their products.

What other advice do I have?

Use as many features as possible but the more you rely on Enterprise Manager, the more you must remove and SPOF by having redundancy (RAC clusters or whatever failover solution you choose) and having a hot backup in a separate data center using data guard or some other replication technology so that if your data center goes down you can still bring up Enterprise Manager some where else.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user79794 - PeerSpot reviewer
Database Expert with 51-200 employees
Vendor
OEM 12c - fairly straight forward on all ends, minor stability issues that resolved itself

What is most valuable?

Real Time monitoring i.e SQL Monitoring and the ADDM

How has it helped my organization?

We have setup dashboards for the SMT (Senior Management Team) to give them a traffic light system on a very high level – enough for them to know that all systems are up and available

What needs improvement?

Costs of add-on’s and management packs i.e AWS (Amazon) and Golden Gate

For how long have I used the solution?

3-4 years across 3 different jobs.

What was my experience with deployment of the solution?

None, quite straight forward (having already deployed and installed weblogic before)

What do I think about the stability of the solution?

Just on a few occasions agent connectivity to repository would fail resulting in “stuck” messages on the OEM screens, resolved itself overnight – weird?

What do I think about the scalability of the solution?

No

How are customer service and technical support?

Customer Service: ExcellentTechnical Support: Excellent

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

Just the old OEM 10g/11g

How was the initial setup?

Fairly straight forward. The download zip files have everything you need in one place and instructions are simple to follow for those who have experience in Oracle installations.

What about the implementation team?

Installed by DBATEAM onsite

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

Setup costs are absorbed by the Enterprise licenses we already hold, but as we run OEM from Amazon cloud services we have daily costs for server/disk/networks etc. Hard to give a figure as it depends on what Amazon service we use

Which other solutions did I evaluate?

No

What other advice do I have?

If you are already paying for enterprises licenses then it’s rude not to use it!
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

The number of plugins available makes this tool quite valuable for enterprise.

See all 4 comments
reviewer960693 - PeerSpot reviewer
Software Developer at a tech services company with 10,001+ employees
Consultant
The masking features are good, and many new options and features are available in OEM for masking

What is our primary use case?

For masking purposes, and for case studies with the other existing masking tools existing in the market.

How has it helped my organization?

It has a very good user interface, and the controls are user-friendly. Many useful options are available.

What is most valuable?

The masking features are good, and many new options and features are available in OEM for masking when compared to other tools.

What needs improvement?

With regards to masking still, some options could be added like running in simulation mode, creation of audit file option, file summary, file after masking.

For how long have I used the solution?

Less than one year.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user744699 - PeerSpot reviewer
Database Administrator Manager at a international affairs institute with 11-50 employees
Vendor
Able to monitor several other database products across various OS platforms

What is most valuable?

  • Remote administration
  • Corrective actions
  • Custom reports
  • Oracle Secure Backup integration
  • Exadata/SuperCluster plugin

How has it helped my organization?

  • Corrective action reduces the occurrences of business impacting outages.
  • Alerts enable us to proactively address issues.
  • Reporting features allow us to monitor storage usage over time, thus perform effective capacity predictions.

What needs improvement?

OS level integration

Better integration with NetBackup

For how long have I used the solution?

Five years.

What do I think about the stability of the solution?

Yes. However, this was due to a storage capacity issue with the repository DB.

What do I think about the scalability of the solution?

No issues.

How are customer service and technical support?

Fair, when needed.

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

Shell scripts. The reasons to switch were obvious.

How was the initial setup?

It was straightforward. It was done in conjunction with consultant support.

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

If you can avoid all that by creating a comprehensive ULA, then that's the route to go.

Which other solutions did I evaluate?

No.

What other advice do I have?

Excellent product for enterprise monitoring: The tool is able to monitor several other database products across various OS platforms. All database-related tasks can be performed on an Oracle DB from inside this tool.

I do recommend deploying agents on everything you can find, then going to see what useful data exists in your management views.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user435981 - PeerSpot reviewer
Programmer/Analyst at Lidestri Foods
Vendor
The most valuable feature is that it goes hand-in-hand with our EDI. There are performance issues that we see tied to SOA Suite and the B2B functioning.

Valuable Features

The most valuable feature of OEM is that it goes hand-in-hand with our EDI. Essentially, it allows us to operate the SOA Suite solution on a management level.

Improvements to My Organization

The biggest improvement Enterprise Manager has provided us is that it allows for easy maintenance and setup of our user base that's surrounded by SOA Suite.

Room for Improvement

The issues we've had with Enterprise Manager go hand-in-hand with our issues with SOA Suite. There are performance issues that we see tied to SOA Suite and the B2B functioning, all of which impacts Enterprise Manager.

Deployment Issues

We've had no issues deploying it.

Stability Issues

There have been no problems with its own instability, just with performance that's tied to SOA Suite.

Scalability Issues

We don't have that many functional users using it, so scaling has not been a true issue for us.

Customer Service and Technical Support

We use a third-party hosting solution. A lot of the setup in technical maintenance is all handled through them. I know we've logged several SR's for the OEM issues related to the SOA Suite issues.

Implementation Team

This was set up through our third-party implementer.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user522156 - PeerSpot reviewer
Analyst at a tech services company with 1,001-5,000 employees
Consultant
Presents the full picture, everything in one place

What is most valuable?

Everything you do; you can see the whole picture. You can everything in one place. That's very good, very convenient.

What needs improvement?

Easier to read. For example, on the home page of information, under Adm, that should be a little bit easier to read. Sometimes you have to spend a lot of time to read and understand what's going on there.

What do I think about the stability of the solution?

Very stable.

What do I think about the scalability of the solution?

Scaling is okay.

How is customer service and technical support?

I've opened tickets a few times. They are quick to respond, get back to you quickly. I'm happy with it.

What other advice do I have?

I would recommend learning and using OEM right away. It will cut down the time put in by DBAs a lot, by using OEM.

I'm very happy with OEM.

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