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) |