Database Administration (MOSC)

MOSC Banner

Delete of PDML in 12c does not work


SQL*Plus: Release 12.2.0.1.0 Production on Tue Mar 12 10:04:10 2024


Copyright (c) 1982, 2016, Oracle. All rights reserved.


Last Successful login time: Tue Mar 12 2024 18:01:06 +08:00


Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production


SQL> alter session force parallel dml parallel 8;


Session altered.


SQL> explain plan for 

 2 update /*+ enable_parallel_dml parallel(t 2) full(t)*/ WW_TEST_TABLE t set job_ins_id = '11111' ;


Explained.



SQL> select * from table(dbms_xplan.display());


PLAN_TABLE_OUTPUT

------------------------------------------------------------------------------------------------------------------------------------------------------

Plan hash value: 4224494471


---------------------------------------------------------------------------------------------------------------------------

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

---------------------------------------------------------------------------------------------------------------------------

|  0 | UPDATE STATEMENT   |           |   3 |  15 |   7  (0)| 00:00:01 |    |   |      |

|  1 | UPDATE        | WW_TEST_TABLE |    |    |      |     |    |   |      |

|  2 |  PX COORDINATOR   |           |    |    |      |     |    |   |      |

|  3 |  PX SEND QC (RANDOM)| :TQ10000       |   3 |  15 |   7  (0)| 00:00:01 | Q1,00 | P->S | QC (RAND) |

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