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.
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.
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跨节点并行控制见:
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/195110/viewspace-753513/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/195110/viewspace-753513/