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:
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:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center