Oracle Enterprise Manager Reviews

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.

I like the reports of Enterprise Manager, as you have a lot of targets. You can create generic reports based on some metrics of those targets. It allows me to have some sort of place to check all my targets.

I would like to have more details and privileges. Sometimes, I have a problem where I need to grant a user in Enterprise Manager the privilege to view a database. When I grant a privilege to him, to monitor a database, he also gets the privilege to view the host of the database, and I don't want him to show the host, only the database. I would say more grantable and obtainable privileges are needed.

I've been using it for four to five years.

It's very, very stable.

It's been able to scale for our needs.

I never needed support for Oracle. The packages that they offer are very good. I never need to contact any guys from Oracle to perform support.

It's very easy to setup, not for someone who has never worked with it, but if you had junior or someone a little more experienced than a junior, they are good enough to deploy. It's easy to deploy.

Before deploying a new service, be sure you configure it very well, because it's very boring and time consuming to later do this. It would be good to do this during the deployment phase. That is what I would think.