更新时间:2022-01-30 22:14:28
如何?像这样:
SQL> alter session enable parallel dml;
Session altered.
SQL> merge /*+ parallel(10) */ into emp e
2 using dept d
3 on (d.deptno = e.deptno)
4 when matched then update set
5 e.comm = e.comm * 1;
14 rows merged.
SQL>
PARALLEL
提示将启用读并行,但要同时启用写并行,您需要运行上述 ALTER SESSION
命令或使用提示 /*+ ENABLE_PARALLEL_DML */
.
The PARALLEL
hint will enable read-parallelism, but to also enable write-parallelism you will need to either run the above ALTER SESSION
command or use the hint /*+ ENABLE_PARALLEL_DML */
.