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:
-
Access the Performance Hub page, as explained in "Monitoring User Activity".
-
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.