DDL Parallel
Hi,
I tried to move 1 particular LOB partition from one tablespace to another tablespace using parallel clause, but it was taking time & my understanding would be its going in serial fashion (parallel was not effect), Can you pls clarify ?
execution plan
SQL> /PLAN_TABLE_OUTPUT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------SQL_ID b9hry1x4scfqx--------------------alter table core.cloPlan hash value: 2771440782----------------------------------------------------------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib |----------------------------------------------------------------------------------------------------------------------------------| 0 | CREATE TABLE STATEMENT | | | | 105 (100)| | | | | | || 1 | LOAD AS SELECT | | | | | | | | | | || 2 | PX COORDINATOR | | | | | | | | | | || 3 | PX SEND QC (RANDOM) | :TQ10000 | 834K| 117M| 105 (0)| 00:00:02 | | | Q1,00 | P->S | QC