Elapsed: 00:09:580.37

Execution Plan
----------------------------------------------------------
   0      INSERT STATEMENT Optimizer=CHOOSE (Cost=27 Card=431196 Bytes
          =4743156)

   1    0   NESTED LOOPS* (Cost=27 Card=431196 Bytes=4743156)          :Q480000
                                                                       0

   2    1     TABLE ACCESS* (FULL) OF 'TABLE2' (Cost=1 Card=13 By :Q480000
          tes=39)                                                      0

   3    1     TABLE ACCESS* (BY INDEX ROWID) OF 'TABLE1' ( :Q480000
          Cost=2 Card=431196 Bytes=3449568)                            0

   4    3       INDEX* (RANGE SCAN) OF 'IDX3_TABLE1' (NON- :Q480000
          UNIQUE) (Cost=1 Card=431196)                                 0



   1 PARALLEL_TO_SERIAL            SELECT /*+ ORDERED NO_EXPAND USE_NL(A2) INDE
                                   X(A2 "IDX3_TABLE1") */ A

   2 PARALLEL_COMBINED_WITH_PARENT
   3 PARALLEL_COMBINED_WITH_PARENT
   4 PARALLEL_COMBINED_WITH_PARENT


Statistics
----------------------------------------------------------
        237  recursive calls
    1325646  db block gets
      17816  consistent gets
     242723  physical reads
  155667036  redo size
        540  bytes sent via SQL*Net to client
        835  bytes received via SQL*Net from client
          4  SQL*Net roundtrips to/from client
          5  sorts (memory)
          0  sorts (disk)
     434009  rows processed