OEM great for Oracle dbs and current hardware; older vendors, not so much
- Provides a graphical interface to Oracle Database metrics (therefore one does not need to manually execute queries on a database to find information).
- Provides a graphical interface to hardware metrics (like cpu, memory, network, i/o utilization). This is very important as it allow non system administrators to view and understand information regarding the hardware that an Oracle Database is running on.
- Has built in features to dynamically build databases, implement RAC (cluster), implement Data Guard, and many other optional add on features to Oracle databases.
- Has the ability to generate performance data (and other) reports that can be also be easily delivered within the organization, all through the OEM interface.
Cons
- Information can sometimes be hard to find within OEM. There are so many different attributes that it can be difficult to find the exact area where key information can be found.
- If OEM is running slowly, it can be hard to diagnose where the problem exists.
- If OEM is having a performance issues and disconnects, all data is lost. This can be particularly frustrating if reports are being generated or a data guard configuration is being implemented.
- Configuring credential setup can be very time consuming and confusing. There should be a central user that has base level OEM access for any database added to the OEM OMS repository.
- Manually inputting credentials is very onerous.
- As a graphical interface, not all query information is provided and therefore it can be difficult to hone a dba skill set. Since not all queries are shown, if OEM is unavailable, one will not know how to retrieve the same information directly from the database.