Parallel Query 
This sub-monitor in the SAP/Oracle Database Monitor lets you check parallel queries. Instead of using a single process for one SQL statement, in parallel queries the work is spread across multiple processes. This is useful where there is a lot of data in operations like full table scans of large tables, creation of large indexes, or bulk inserts, updates, and deletes.
You choose 
Performance
Feature Monitoring Parallel
Query 
in the DBA Cockpit.
You cannot view history information in this monitor.
Structure
This screen displays the following information:
Column |
Description |
|---|---|
Parallel Coor. |
Parallel coordinator number |
SID |
System ID number |
Username |
User name |
Inst ID |
Instance ID |
Server Group |
Server group |
Server Set |
Server set |
log. Nb.DB Proc. |
Logical number of DB process |
Inst of Coord. |
Instance of coordinator |
Degree |
Degree of parallelism |
Req. Degree |
Required degree of parallelism |