oracle11g 并行查询,Oracle11gRAC跨节点 并行查询的控制

Oracle11gRAC跨节点并行查询的控制，跟先前的版本有所变化：

参数instance_groups被废弃，并新增加了参数：PARALLEL_FORCE_LOCAL来限制内部节点的并行操作．

使用Services来确定并行查询将在哪些节点上执行．

参数PARALLEL_INSTANCE_GROUP设置为Service的名称.

下为官方说明：

Parallel Operations and Services

By default, in an Oracle RAC environment, a SQL statement executed in parallel can

run across all of the nodes in the cluster. For this cross-node or inter-node parallel

execution to perform. well, the interconnect in the Oracle RAC environment must be size appropriately because inter-node parallel execution may result in a lot of interconnect traffic. To limit inter-node parallel execution, you can control parallel

execution in an Oracle RAC environment using the PARALLEL_FORCE_LOCAL

initialization parameter. By setting this parameter to TRUE, the parallel execution

servers can only execute on the same Oracle RAC node where the SQL statement was started.

Services are used to limit the number of instances that participate in a parallel SQL

operation. When the default database service is used, the parallel SQL operation can run on all available instances. You can create any number of services, each consisting of one or more instances. When a parallel SQL operation is started, the parallel execution servers are only spawned on instances which offer the specified service used in the initial database connection.

PARALLEL_INSTANCE_GROUP is an Oracle RAC parameter that, when used in

conjunction with services, lets you restrict parallel query operations to a limited

number of instances.To restrict parallel query operations to a limited number of instances, set the PARALLEL_INSTANCE_GROUP initialization parameter to the name of a service. This does not affect other parallel operations such as parallel recovery or the processing of GV$ queries.

附：

Oracle10gRAC跨节点并行控制见：