Monitoring Top PL/SQL

The Top PL/SQL table displays the top PL/SQL subprograms waiting for the corresponding wait event during the selected time period. If a single PL/SQL subprogram is using the majority of the wait time, then you should investigate it.

To monitor a PL/SQL subprogram: 

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

   The Active Sessions Working page appears.

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

   The Top PL/SQL table appears.

3. Click the PL/SQL Subprogram link of the most active subprogram.

   The PL/SQL Subprogram page appears.

   This page contains statistics for the selected subprogram.