Parallel Query 

Definition

This submonitor 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.

Use

You choose Detailed Analyses ®  Overall activity  ® Parallel Query.

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