alter session enable parallel dml
或
execute immediate 'alter session enable parallel dml'; 修改会话并行DML
select /*+parallel(a,4)*/ * from table_name a
select /*+parallel(a,4) parallel(b,4) parallel(c,4)*/ a.*,b.*,c.* from table_name1 a,table_name2 b,table_name c
insert /*+parallel(t,4)*/ into table_name t
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/658698/viewspace-265030/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/658698/viewspace-265030/