4.10 The Waits Page
Available only if you sign in as a database user with the DBA role and for
Oracle Database 18c and previous releases.
The Waits page shows a chart with the distribution of wait events in real time.
Use the slider controls in the small chart to zoom in on a specific time period in the chart above. 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 4-5 Distribution of Wait Events Chart
Description of "Figure 4-5 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.
