Using Waits
Note
Available only if you signed in as a database user with DBA and PDB_DBA roles.
Available only if you signed in as a database user with DBA and PDB_DBA roles.
The Waits page shows a chart with the distribution of wait events in real
time.
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.

When you place the cursor over data points in the chart, a pop-up box displays details about the wait event.
