Add the +PARALLEL format when calling it to get these columns:
create table t as
select level c1 from dual
connect by level <= 100;
set serveroutput off
explain plan for
select /*+ parallel */count (*) from t;
select *
from table(dbms_xplan.display(null, null, '+PARALLEL'));
--------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib |
--------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 2 (0)| 00:00:01 | | | |
| 1 | SORT AGGREGATE | | 1 | | | | | |
| 2 | PX COORDINATOR | | | | | | | |
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 1 | | | Q1,00 | P->S | QC (RAND) |
| 4 | SORT AGGREGATE | | 1 | | | Q1,00 | PCWP | |
| 5 | PX BLOCK ITERATOR | | 100 | 2 (0)| 00:00:01 | Q1,00 | PCWC | |
| 6 | TABLE ACCESS FULL| T | 100 | 2 (0)| 00:00:01 | Q1,00 | PCWP | |
--------------------------------------------------------------------------------------------------------
If you get the execution plan with display_cursor (which is what you want, really) then when running in parallel you should get these anyway:
select /*+ parallel gather_plan_statistics */count (*) from t;
select *
from table(dbms_xplan.display_cursor(null, null, 'ALLSTATS ALL'));
-----------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | Cost (%CPU)| E-Time | TQ |IN-OUT| PQ Distrib | A-Rows | A-Time | Buffers | Reads |
-----------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 2 (100)| | | | | 1 |00:00:00.01 | 3 | 0 |
| 1 | SORT AGGREGATE | | 1 | 1 | | | | | | 1 |00:00:00.01 | 3 | 0 |
| 2 | PX COORDINATOR | | 1 | | | | | | | 2 |00:00:00.01 | 3 | 0 |
| 3 | PX SEND QC (RANDOM) | :TQ10000 | 0 | 1 | | | Q1,00 | P->S | QC (RAND) | 0 |00:00:00.01 | 0 | 0 |
| 4 | SORT AGGREGATE | | 2 | 1 | | | Q1,00 | PCWP | | 2 |00:00:00.01 | 2 | 5 |
| 5 | PX BLOCK ITERATOR | | 2 | 100 | 2 (0)| 00:00:01 | Q1,00 | PCWC | | 100 |00:00:00.01 | 2 | 5 |
|* 6 | TABLE ACCESS FULL| T | 1 | 100 | 2 (0)| 00:00:01 | Q1,00 | PCWP | | 100 |00:00:00.01 | 2 | 5 |
-----------------------------------------------------------------------------------------------------------------------------------------------------------
There is no specific column for these in the v$ views, it's in the other_tag:
select operation, other_tag
from v$sql_plan_statistics_all
where plan_hash_value = '3126468333';
OPERATION OTHER_TAG
SELECT STATEMENT <null>
SORT <null>
PX COORDINATOR <null>
PX SEND PARALLEL_TO_SERIAL
SORT PARALLEL_COMBINED_WITH_PARENT
PX BLOCK PARALLEL_COMBINED_WITH_CHILD
TABLE ACCESS PARALLEL_COMBINED_WITH_PARENT