Oracle Database - The Query Coordinator (QC)

Card Puncher Data Processing

About

The QC is the session that initiates the parallel SQL statement and the PX servers are the individual sessions that perform work in parallel.

The QC distributes the work to the PX servers and may have to perform a minimal – mostly logistical – portion of the work that cannot be executed in parallel.

For example a parallel query with a SUM() operation requires a final adding up of all individual sub-totals calculated by each PX server.

The QC is easily identified in a parallel execution plans as 'PX COORDINATOR'. The process acting as the QC of a parallel SQL operation is the actual user session process itself.





Discover More
Card Puncher Data Processing
Oracle Database - (Parallel|PX) Server

Execution Thread in Oracle. Parallel server are the individual sessions that perform work in parallel in a parallel SQL execution. PX server processes can be easily identified on the OS level, for...
Oracle Database Hash Redistribution
Oracle Database - Data Redistribution (Parallel)

Data redistribution is not unique to the Oracle Database. In fact, this is one of the most fundamental principles of parallel processing, being used by every product that provides parallel capabilities....
Oracle Database Sql Parallel Execution Principle
Oracle Database - SQL Parallel Execution

Parallel execution was first introduced in Oracle Version 7.3 in 1996 Oracle will make use of Parallel when a table or a statement is marked as “Parallel”. The concept of parallelism is when many...



Share this page:
Follow us:
Task Runner