Oracle Enterprise Manager Reviews

Real Time monitoring i.e SQL Monitoring and the ADDM

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

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

3-4 years across 3 different jobs.

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

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

No

Customer Service: ExcellentTechnical Support: Excellent

Just the old OEM 10g/11g

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.

Installed by DBATEAM onsite

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

No

If you are already paying for enterprises licenses then it’s rude not to use it!

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.

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.

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.

We've had no issues deploying it.

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

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

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.

This was set up through our third-party implementer.

Performance tuning, segment and memory advisor

All our production systems are monitored by OEM to get the alerts and warnings and deal with it

One of the biggest issues, specially for 12c grid contro,l is the performance; to be able to monitor and find the root cause of performance issue immediately, in real time. It is important for the grid control to perform quickly in order to minimize the time of investigation and to identify the root cause and required solution,

6 years

Some times with 12C

No

No

For Oracle databases and Oracle products in general, OEM is the best monitoring / console solution to get live and historical overview on your systems

Performance tuning, Alerting, SQL Tuning, Database Reporting

Generating a graphical report on the fly, Diagnose any performance issues

There is not much negative about OEM. But with newer versions, maybe more reporting functionality can be added.

4 years

On a scale from 1 to 5 I would give it a 4.

The installation was straightforward

In-house team

Oracel Enterprise Manager is must if you have too many oracle databases across the landscape

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

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

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

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.

Less than one year.

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

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

OS level integration

Better integration with NetBackup

Five years.

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

No issues.

Fair, when needed.

Shell scripts. The reasons to switch were obvious.

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

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

No.

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.

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

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

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.

2 years

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

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.

Oracle support is helpful and knowledgeable.

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.

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.

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

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.

Very stable.

Scaling is okay.

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

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.