The Session Waits page shows the amount of time a session spent waiting for resources to become available.
When an Oracle session needs a resource that is not available or performs disk I/O, Oracle records the type and duration of the wait.
To open the Session Waits page
Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
Click Top Sessions Page.
Note: Alternatively, you can view session waits for top sessions by I/O Time on the IO | Session Waits Page.
Data on the Session Waits page
Data |
Description |
---|---|
Current wait |
If the wait is for a file IO operation (such as db file sequential read or db file scattered read) Spotlight displays the name of the table or index to which the IO is occurring. If you selected fast initialization (Oracle Initialization) when you connected to the database, the name of the table or index is not shown. |
Wait state (time) |
The status of the wait, and how long it has waited. |
The Session Waits Grid
This table lists details of all wait events.
Tips:
Charts on the Session Waits page
Chart |
Description |
---|---|
Resource usage |
The pie chart shows a breakdown of total resource waits by category. |
Wait Events |
The chart shows a history of wait events. The legend to the right shows the different categories of wait events displayed. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center