oracle并行使用

DELETE /*+ PARALLEL(EMP, 3) */ from EMP;

SELECT /*+ PARALLEL(emp,4) */ COUNT(*)
FROM emp;

insert /*+ parallel (emp_big,4) */
into emp_big select * from emp;

CREATE table emp(id number(10))
PARALLEL (4);

alter table emp noPARALLEL

CREATE INDEX emp_ix ON emp (emp_id)
PARALLEL (4);

alter index emp_ix noPARALLEL