direct-path [insert] parallel
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@]
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Direct-Path InsertOracle
- Append與Direct-Path Insert(一)APP
- Append與Direct-Path Insert(二)APP
- 使用Direct-Path INSERT插入資料到表中
- [Oracle] Insert into速度測試nologging+parallelOracleParallel
- Direct Path Insert與APPEND, PARALLEL的梳理與小結APPParallel
- oracle hint_no_parallel_no_parallel_indexOracleParallelIndex
- oracle hint_parallel_parallel_indexOracleParallelIndex
- 11g資料庫大表資料快速清理方法 - insert+append+parallel+exchange (2)資料庫APPParallel
- 11g資料庫大表資料快速清理方法 - insert+append+parallel+exchange (1)資料庫APPParallel
- Tasks in parallelParallel
- Parallel DMLParallel
- Oracle中的insert/insert all/insert firstOracle
- about datapump parallelParallel
- 並行(Parallel)並行Parallel
- Oracle Parallel ParametersOracleParallel
- Oracle's ParallelOracleParallel
- Oracle Parallel ExecutionOracleParallel
- Parallel query & viewsParallelView
- Oracle Parallel DMLOracleParallel
- oracle parallel並行_引數parameter_parallel_max_serverOracleParallel並行Server
- PARALLEL_DEGREE_POLICParallel
- parallel_max_serversParallelServer
- Parallel操作測試Parallel
- Parallel Execution of SQL StatementsParallelSQL
- oracle Parallel技術OracleParallel
- db file parallel writeParallel
- 關於Parallel queryParallel
- Oracle 的 INSERT ALL和INSERT FIRSTOracle
- 【Direct-Path】直接路徑載入提升插入效率及其自身限制
- insert /*+ append */ into 與insert into 的區別APP
- INSERT ALL 和INSERT FIRST 的區別
- Oracle db file parallel write 和 log file parallel write 等待事件 說明OracleParallel事件
- Multitable Insert
- 使用parallel注意事項Parallel
- parallel_index不生效ParallelIndex
- Understanding Parallel Execution PlanParallel
- SMON: Parallel transaction recovery triedParallel