Track Session Page
The Track Session page allows you to track the session's resource usage.
To open the Track Session page
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click I/O | Sessions Page.
- Select a Session in the Top Sessions grid.
- Click Track Session.
Note: Alternatively, you can track resource usage on the Top Sessions | Track Session Page.
Charts on the Track Session page
Notes:
- Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on the chart.
- Click an item in the legend to highlight its series (line) in the chart. Click a second time to return the series to its normal appearance.
- Move the mouse pointer over an item in the legend to view the current value for that series within the chart.
| Wait events (ms/s) |
The rate at which waits for various Oracle resources are occurring. For more information about wait events, see Deal With Wait Events. |
| I/O history (IO/s) |
The rate at which the session is performing database read I/O. The following information is displayed:
- Consistent - The rate of logical I/O performed for query purposes.
- Physical - Indicates the rate of physical disk reads.
- Current - Gets obtained for update purposes.
|
| CPU (ms/s) |
The rate at which CPU is consumed. |
| Call history (calls/s) |
The rate of database calls per second. |
Related Topics
Spotlight on Oracle Drilldowns
