Monitoring Top Objects

The Top Objects table displays the top database objects waiting for the corresponding wait event during the selected time period. This data is available from the Active Sessions Waiting: User I/O page.

To monitor an object: 

1. On the Performance page, in the Average Active Sessions chart, click the User I/O block on the chart or its corresponding wait class in the legend.

   The Active Sessions Waiting: User I/O page appears.

2. Under Detail for Selected 5 Minute Interval, select Top Objects from the View list.

   The Top Objects table appears.

3. Click the Object Name link of the object with the highest average wait time.

   The View page for the object appears.