There also are some brown spikes that point to concurrency issues. The green indicates user sessions that are actively using the available CPU capacity or waiting for other system resources, as you can see from the legend on the right. Signing on to EM and selecting a database leads to the Performance Home screen, which displays a chart that tracks the performance of the database based on Oracle's average active sessions value.įigure 1 shows a screenshot of that chart. One of the best features of Enterprise Manager is the ability to see the performance of an Oracle database at a glance. An at-a-glance view of Oracle performance To explain why, let's look at what EM and two popular third-party tools offer database administrators (DBAs) for that particular aspect of managing Oracle databases. But you may also want to consider third-party Oracle database monitoring tools to support your performance tuning and management needs, even if you already use EM.

You may find Enterprise Manager (EM) to be a very useful product.

Toad database monitor