Item: Oracle Enterprise Manager
Rating: 9
Author: Verified User

Overall Satisfaction with Oracle Enterprise Manager

Use Cases and Deployment Scope

OEM is an excellent tool used by our organization for our day to day activities for the DBA staff. I work and assist my DBA Team to monitor, performance tune, and run the SQL analyzer for the different databases which can be controlled from within the OEM. Currently, it is being used by our IT Oracle DBA Team and without this tool, it is difficult to support our daily operations

Pros and Cons

Pros

Top SQL performance
Once place for space management for different databases
SQL tuning advisor

Cons

The dashboard sometimes is slow based on the charts and graphs being displayed. Certain drill-downs can definitely be improved in speed.
The central page after we log in contains too many objects which make it more cluttered and becomes difficult to view the necessary sections.
Login process can be more efficient encase you have just one SSO.

Return on Investment

Very nice tool. It cannot operate or support operations without this tool.
Very helpful tool used for DBA and performance management.

Alternatives Considered

Have not used any other products.

Other Software Used

Oracle eBusiness Suite, Oracle Warehouse Builder, Oracle Application Express

Likelihood to Recommend

SQL tuning, SQL plan advisor, hint implementation, TOP SQL, database management and space management. One point source for controlling and extending all tablespaces.

Comments

Please log in to join the conversation

OEM: A life saver for Oracle professionals