Is Parallelism happening at INSERT level?

We are trying to tune a query to use parallelism at multiple levels. Here is the query along with the plan gotten by using dbms_xplan:

PLAN_TABLE_OUTPUT

| Id  | Operation                          | Name       | Rows  | Bytes |
Cost (%CPU)| Time     | Pstart| Pstop |    TQ  |IN-OUT| PQ Distrib |
----------------------------------------------------------------------------------------------------------------------------------------------


|   0 | INSERT STATEMENT                   |            |       |       |


2840K(100)|          |       |       |        |      |            |


|   1 |  PX COORDINATOR                    |            |       |       |


          |          |       |       |        |      |            |


|   2 |   PX SEND QC (RANDOM)              | :TQ10000   |    30M|    10G|


2840K  (1)| 00:01:51 |       |       |  Q1,00 | P->S | QC (RAND)  |


|   3 |    LOAD AS SELECT (HYBRID TSM/HWMB)|            |       |       |


          |          |       |       |  Q1,00 | PCWP |            |


|   4 |     OPTIMIZER STATISTICS GATHERING |            |    30M|    10G|


2840K  (1)| 00:01:51 |       |       |  Q1,00 | PCWP |            |
|*  5 |      HASH JOIN RIGHT SEMI          |            |    30M|    10G|
2840K  (1)| 00:01:51 |       |       |  Q1,00 | PCWP |            |


|   6 |       TABLE ACCESS FULL            | efgh       |   193K|  1131K|


  36   (3)| 00:00:01 |       |       |  Q1,00 | PCWP |            |


|   7 |       PX BLOCK ITERATOR            |            |  1547M|   536G|


2839K  (1)| 00:01:51 |     1 |    32 |  Q1,00 | PCWC |            |
|*  8 |        TABLE ACCESS FULL           | sce |  1547M|   536G|  2839K
(1)| 00:01:51 |     1 |    32 |  Q1,00 | PCWP |            |
----------------------------------------------------------------------------------------------------------------------------------------------

• dynamic statistics used: dynamic sampling (level=AUTO) PLAN_TABLE_OUTPUT

  ---

• Degree of Parallelism is 4 because of hint

Given that P->S happens in line id 2, is this statement using parallelism for the INSERT part of it? I can see a parallelism of 4 reported at the v$px_session table for this SQL. Should I see 8 rows if there is parallelism of 4 for SELECT and INSERT each?

Dont know why it is saying the statement will complete in 1:51. It has been running for an hour. The waits are all on 'direct path read/writes'. we have some bad IO, but still finding ways to tune the statement. ver is 12c.

Thanks
Ram

--

--
http://www.freelists.org/webpage/oracle-l