Oracle Enterprise Manager Review

It's easy to find blocking or locking queries, to kill queries, and to explore table structure.


Valuable Features:

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

Improvements to 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

Room for 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.

Use of Solution:

2 years

Stability Issues:

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

Scalability Issues:

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.

Customer Service:

Oracle support is helpful and knowledgeable.

Previous Solutions:

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.

Other Advice:

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.
Add a Comment
Guest

Sign Up with Email