You have enabled DML by issuing: ALTER session ENABLE PARALLEL DML; The PARELLEL_DEGREE_POLICY initialization parameter is set to AUTO. Which two options true about DML statements for which parallel…

The correct answer is C. Statements for which PDML is requested will always execute in parallel if estimated execution in parallel D. Statements for which PDML is requested will be queued if the number of busy parallel execution servers. C: PARALLEL_MIN_TIME_THRESHOLD specifies the minimum execution time a statement should have before the statement is considered for automatic degree of parallelism. By default, this is set to 30 seconds. Automatic degree of parallelism is only enabled if PARALLEL_DEGREE_POLICY…

Understanding and Influencing the Optimizer

Question

You have enabled DML by issuing:

ALTER session ENABLE PARALLEL DML; The PARELLEL_DEGREE_POLICY initialization parameter is set to AUTO. Which two options true about DML statements for which parallel execution is requested?

Options

AStatements for which PDML is requested will execute serially estimated time is less than the time
BStatements for which PDML is requested will be queued if the number of busy parallel execution servers
CStatements for which PDML is requested will always execute in parallel if estimated execution in parallel
DStatements for which PDML is requested will be queued if the number of busy parallel execution servers
EStatement for which PDML is requested will be queued if the number of busy parallel execution servers is

How the community answered

(55 responses)

A
5% (3)
B
2% (1)
C
82% (45)
E
11% (6)

Explanation

C: PARALLEL_MIN_TIME_THRESHOLD specifies the minimum execution time a statement should have before the statement is considered for automatic degree of parallelism. By default, this is set to 30 seconds. Automatic degree of parallelism is only enabled if PARALLEL_DEGREE_POLICY is set to AUTO or LIMITED. D: PARALLEL_SERVERS_TARGET specifies the number of parallel server processes allowed to run parallel statements before statement queuing will be used. When the parameter PARALLEL_DEGREE_POLICY is set to AUTO, Oracle will queue SQL statements that require parallel execution, if the necessary parallel server processes are not available. Statement queuing will begin once the number of parallel server processes active on the system is equal to or greater than PARALLEL_SERVER_TARGET. * PARALLEL_DEGREE_POLICY specifies whether or not automatic degree of Parallelism, statement queuing, and in-memory parallel execution will be enabled. Enables automatic degree of parallelism, statement queuing, and in-memory parallel execution. * PARALLEL_MIN_SERVERS specifies the minimum number of parallel execution processes for the instance. This value is the number of parallel execution processes Oracle creates when the instance is started.

Topics

#parallel DML#PARALLEL_DEGREE_POLICY#statement queuing#parallel server

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice