|
SQL> conn chf/xifenfei
Connected.
SQL> EXPLAIN PLAN FOR INSERT INTO t_1
SELECT * FROM
t1;
Explained.
SQL> SELECT
* FROM table
(DBMS_XPLAN.display(NULL,
NULL, 'BASIC
+PARALLEL'));
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 2494645258
----------------------------------------------------------------------
|
Id |
Operation
| Name
|
TQ |IN-OUT| PQ Distrib
|
----------------------------------------------------------------------
| 0 |
INSERT STATEMENT
|
|
|
|
|
| 1
| PX
COORDINATOR
|
|
|
|
|
| 2
| PX SEND QC (RANDOM)| :TQ10000
| Q1,00 | P->S | QC (RAND)
|
| 3
| PX BLOCK
ITERATOR
|
| Q1,00 | PCWC
|
|
| 4
|
TABLE ACCESS FULL|
T1
| Q1,00 | PCWP
|
|
----------------------------------------------------------------------
SQL> conn chf/xifenfei
Connected.
SQL> ALTER
SESSION ENABLE PARALLEL
DML;
Session altered.
SQL> EXPLAIN PLAN FOR INSERT INTO t_1
SELECT * FROM
t1;
Explained.
SQL> SELECT
* FROM table
(DBMS_XPLAN.display(NULL,
NULL, 'BASIC
+PARALLEL'));
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 783041698
-------------------------------------------------------------------------
|
Id |
Operation
| Name
|
TQ |IN-OUT| PQ Distrib
|
-------------------------------------------------------------------------
| 0 |
INSERT STATEMENT
|
|
|
|
|
| 1
| PX
COORDINATOR
|
|
|
|
|
| 2
| PX SEND QC
(RANDOM) | :TQ10001
| Q1,01 | P->S | QC (RAND)
|
| 3
|
LOAD AS SELECT
|
T_1
| Q1,01 | PCWP
|
|
| 4
|
PX
RECEIVE
|
| Q1,01 | PCWP
|
|
| 5
|
PX SEND ROUND-ROBIN| :TQ10000 | Q1,00 | P->P |
RND-ROBIN |
| 6
|
PX BLOCK ITERATOR
|
| Q1,00 | PCWC
|
|
| 7
|
TABLE ACCESS FULL|
T1
| Q1,00 | PCWP
|
|
-------------------------------------------------------------------------
|
