Which two actions can restrict the number of instances …

Which two actions can restrict the number of instances used for parallel execution of a SQL statement?
(Choose two.)

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

Explanation:
https://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm



Leave a Reply 2

Your email address will not be published. Required fields are marked *


sm

sm

B,D ( B assuming PARALLEL_FORCE_LOCAL ) , if not A,D