Monitoring Parallel Execution

The Parallel Execution charts show system metrics related to parallel queries. A parallel query divides the work of executing a SQL statement across multiple processes. The charts show parallel queries that were waiting for a particular wait event that accounted for the highest percentages of sampled session activity.

To monitor parallel execution: 

1. From the Database Home page, click Performance.

   The Performance page appears.

2. In the instance activity chart, click Parallel Execution.

   The Parallel Execution charts appear.

   Two pairs of charts are displayed. The first pair of charts shows the number of sessions on the y-axis, whereas the second pair shows the per second rate on the y-axis.