- 最后登录
- 2023-8-16
- 在线时间
- 1686 小时
- 威望
- 2135
- 金钱
- 50532
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 5207
- 精华
- 39
- 积分
- 2135
- UID
- 2
|
5#
发表于 2012-4-27 23:52:32
Parallel Execution 当然会利用到 多CPU 的优势
在Unix/Linux下 Parallel Execution 会分配多个Slave Process 协同并行处理 Parallel Query or DML ,理论上 一个 Server Process 同一时间 只能运行在一个CPU 上, 而因为 多个并行进程协作处理的关系 ,Parallel Execution 可以充分利用 多CPU的优势
在Windows下 Parallel Execution 会分配多个Slave Thread 可以起到同等的作用。
Parallel Execution
Oracle's parallel execution features enable Oracle to divide a task among multiple processes in order to complete the task faster. This allows Oracle to take advantage of multiple CPUs on a machine. The parallel processes acting on behalf of a single task are called parallel slave processes. Parallel execution features first were introduced in Oracle Version 7.1 in the form of the Parallel Query Option, which supported only parallel SELECT statements. Since then many new functions have been added. In Oracle7, support for parallel execution was a separately installed option. However, in Oracle8 and Oracle8i, it is embedded into the Oracle RDBMS product. |
|