Oracle sessions are the living part of the database; they are the elements that keep performance views moving. Monitoring instance activity just provides an idea of the average database activity, but this information is not enough to enable the DBA to troubleshoot a particular peak, or to help them identify which user is issuing a resource consuming SQL statement. The monitoring tools provided by Oracle starting with 10g frees the DBA from the time consuming analysis task, and points the DBA to the root of the problem. Those tools not only show what the problem is, but they also categorize the different problems found by impact and provide a diagnostic and a solution.

Enterprise manager, and the session management sections are a complete set of productive tools that allow the DBA to quickly focus on what the problem is, even if this is a complex problem that otherwise would have taken the DBA a lot more time to find out where the root of the problem was.