SQL Performance (MOSC)

MOSC Banner

DDL Parallel

edited Sep 27, 2019 5:10AM in SQL Performance (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center