7.11 The Waits Page
Available only if you signed in as a database user with
DBA and PDB_DBA roles for Oracle
Database 18c and previous releases.
To navigate to the Waits page, do either of the following:
-
In the Database Actions page, click Waits.
-
Click Selector
to display the left navigation pane. Expand the Monitoring menu and select Waits.
Use the slider controls to zoom in on a specific time period. To use the slider controls, place the cursor over the handles at both sides of the box and drag the sides to the time period required. The chart above will refresh to the selected time period. The table will also automatically refresh and the wait events will filter to that period of time enabling you to easily identify the problem SQL statement.
Figure 7-6 Distribution of Wait Events Chart
![Description of Figure 7-6 follows Description of Figure 7-6 follows](img/waitevents.png)
Description of "Figure 7-6 Distribution of Wait Events Chart"
When you place the cursor over data points in the chart, a pop-up box displays details about the wait event.