Oracle Enterprise Manager Reviews

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.

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.

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

It's very expensive.

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

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

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

It's very expensive.

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.

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.

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!

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.