Parallel DML ( alter session enable/disable parallel dml )

When I worked on updating the tables data its used to taken very long time . Since its using single thread that session. To speed up the performance of the update queries we can enable parallel DML for that session which will speed up very efficiently.

alter session enable parallel dml;

update /*+ parallel(t,16) */ SUNIL.KUMAR partition(SYS_P467837) t SET TRANID = '99999';

commit;

alter session disable parallel dml; 

By Using parallel DML we can speed up the Updates against table.


-- Parallel DML for insert


 Parallel Insert DML :- 

alter session enable parallel dml;
insert /*+ parallel (emp_big,4,1) */   into emp_big select * from emp;
commit;
alter session disable parallel dml;