direct-path [insert] parallel

jacksonkingdom發表於2010-04-01
1.direct+parallel
alter session enable parallel dml;
insert /*+ append parallel(XXXX,default)*/ into XXXX select * from YYYY;

2.direct+parallel
create table XXXX parallel as select * from YYYY;

3.direct+parallel
alter session force parallel dml;
alter session force parallel ddl;
create table XXXX as select * from YYYY;

4.direct
create table XXXX as select * from YYYY;
insert /*+ append */ into XXXX select * from YYYY;
[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23590362/viewspace-1034007/,如需轉載,請註明出處,否則將追究法律責任。

相關文章