SQL并行查询
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博客 ” ，链接：https://blog.itpub.net/658698/viewspace-265030/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
通过O43考试
请登录后发表评论
登录
全部评论
最新文章
- Grid Control
- RAC upgrade from 10.2.0.1 to 10.2.0.4
- RAC Troubleshoot
- 11gR2 RAC & EBS R12
- DB Tier 克隆错误，提示打补丁2896876
- 无法直接访问FORM, Prompt error APP-FND-01542
- Upgrading Developer 6i with Oracle E-Business Suite 11i
- Windows 7 certification for Ebusiness suite
- 用SQL操作EBS 维护模式
- After completed ebs migrated, all concurrent managers failed to start except ICM
