Monitoring Resource Consumption

The Average Active Sessions by drop-down contains a Resource Consumption fly-out with the following common views:

• Wait Class

• Wait Event

• Object

• Blocking Session

A session is a logical entity in the database instance memory that represents the state of a current user login to the database. A session lasts from the time a user logs in to the database until the user disconnects. For example, when a user starts SQL*Plus, the user must provide a valid database user name and password to establish a session. If a single session is consuming the majority of database activity, then you should investigate it.

To monitor resource consumption:

1. Access the Performance Hub page, as explained in “Monitoring User Activity”.

2. Click on the drop-down in Average Active Sessions by, mouse onto Resource Consumption, and select the desired view from the fly-out.

   • Wait Class

   • Wait Event

   • Object

   • Blocking Session

   Graphs, tables, and information on the page are updated to reflect the selected criteria.