I have the following execution plan for a parallel query but I can't find
any information about the "TQ" field. Someone can tell me where I can found
informations about it's meaning? I try Oracle manual (Performance tuning
guide) but found
nothing...-----------------------------------------------------------------------------------------------------------------|
Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time
| TQ |IN-OUT| PQ Distrib
|-----------------------------------------------------------------------------------------------------------------|
0 | SELECT STATEMENT | | 1505K| 476M| 7400 (1)|
00:01:29 | | | || 1 | PX COORDINATOR |
| | | | | | | || 2
| PX SEND QC (RANDOM) | :TQ10002 | 1505K| 476M| 7400 (1)| 00:01:29
| Q1,02 | P->S | QC (RAND) ||* 3 | HASH JOIN | |
1505K| 476M| 7400 (1)| 00:01:29 | Q1,02 | PCWP | || 4 |
PX RECEIVE | | 150K| 27M| 499 (1)| 00:00:06 |
Q1,02 | PCWP | || 5 | PX SEND HASH | :TQ10001 |
150K| 27M| 499 (1)| 00:00:06 | Q1,01 | P->P | HASH || 6 |
PX BLOCK ITERATOR | | 150K| 27M| 499 (1)| 00:00:06 |
Q1,01 | PCWC | || 7 | TABLE ACCESS FULL| CUSTOMER |
150K| 27M| 499 (1)| 00:00:06 | Q1,01 | PCWP | || 8 |
BUFFER SORT | | | | | |
Q1,02 | PCWC | || 9 | PX RECEIVE | |
1500K| 205M| 6893 (1)| 00:01:23 | Q1,02 | PCWP | || 10 |
PX SEND HASH | :TQ10000 | 1500K| 205M| 6893 (1)| 00:01:23 |
| S->P | HASH ||* 11 | TABLE ACCESS FULL| ORDERS | 1500K|
205M| 6893 (1)| 00:01:23 | | |
|-----------------------------------------------------------------------------------------------------------------
Received on Fri Mar 10 2006 - 09:49:56 CST
