The Waits page shows wait events for the Oracle database. Deal With Wait Events
To open the Waits page
Click Activity | Waits.
Event Waits Grid
The Event Waits grid shows each individual wait event, together with the rate of waits, and time waited over the past time period.
Tips:
to Show all waits or Hide idle waits. | Column | Description |
|---|---|
|
Event |
The name of the event. |
|
Total waits |
The total number of waits. |
|
Waits/s |
How many waits per second. |
|
% Total |
The percentage of waits of this event against waits of all events. |
|
Total wait time |
The total amount of the time waited, measured in milliseconds. |
|
Wait time/s |
The number of milliseconds waited per second. |
|
% Total |
The percentage of the waited time of this event against waited times of all events. |
|
Avg wait |
The average time waited, measured in milliseconds. |
| Event category |
Event Waits Chart
The Event Waits chart (also available on the Activity | Summary Page ) shows the amount of time (in milliseconds) that sessions have spent waiting on various events per second. Event wait categories from V$SYSTEM_EVENT are aggregated into categories so that they can be graphed.
For more information about wait events, see Deal With Wait Events.
Notes:
