Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)
A.
setting the PARALLEL_DEGREE_POLICY to LIMITED
B.
setting the PARALLEL_FORGE_LOCAL to TRUE
C.
setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS
D.
using a database service to limit the number of instances that participate in parallel execution
E.
creating a UNIFORM service for a policy-managed RAC database
Correct: B,D
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 server processes can only execute on the same Oracle RAC
node where the SQL statement was started.
In Oracle Real Application Clusters, services are used to limit the number of instances that
participate in a parallel SQL operation. The default service includes all available instances.
You can create any number of services, each consisting of one or more instances. Parallel
execution servers are to be used only on instances that are members of the specified service.
When the parameter PARALLEL_DEGREE_POLICY is set to AUTO, Oracle Database
automatically decides if a statement should execute in parallel or not and what degree of
parallelism (DOP) it should use.
Correct: B, D
B,D