RAC的并行执行

10grac 中并行的操作有两个参数决定

   1）INSTANCE_GROUPS

   2）PARALLEL_INSTANCE_GROUP

两个参数一起用来控制并行操作

 

instance_groups是个静态参数  parallel_instance_group是个动态参数但也能被设置在session级别

在parallel_instance_group设置的数值必须已经设置在了instance_group中

MYRAC1.instance_groups='MYRAC','MYRAC1'
MYRAC2.instance_groups='MYRAC','MYRAC2'
MYRAC3.instance_groups='MYRAC','MYRAC3'
MYRAC1.parallel_instance_group='MYRAC1' # executions started on node 1 runs only on node 1
MYRAC2.parallel_instance_group='MYRAC2' # executions started on node 2 runs only on node 2
MYRAC3.parallel_instance_group='MYRAC3' # executions started on node 3 runs only on node 3

上面的例子中

这些设置是指开始的任何节点上的执行的并行将只运行在本节点上

 

MYRAC1.instance_groups='MYRAC','MYRAC1'
MYRAC2.instance_groups='MYRAC','MYRAC2'
MYRAC3.instance_groups='MYRAC','MYRAC3'
MYRAC1.parallel_instance_group='MYRAC1' # executions started on node 1 runs only on node 1 （1上开始的并行运行在1上）
MYRAC2.parallel_instance_group='MYRAC1' # execution started on node 2 runs only on node 1（2上开始的并行运行在1上）
MYRAC3.parallel_instance_group='MYRAC' # execution started on node 3 runs on all nodes  （3上开始的并行运行在所有节点上）

 

也可以在session级别设定

alter session set parallel_instance_group='MYRAC';