Examine the parallel parameters for your instance. All parallel execution servers are available and the session use default parallelism settings. In which two cases will the degree of parallelism be…

The correct answer is B. Statements accessing tables whose dictionary DOP is DEFAULT E. Statements with parallel hints. Note: In earlier versions of the Oracle Database, we had to determine the DOP more or less manually, either with a parallel hint or by setting a parallel degree with alter table. There was an automatic computation of the DOP available for the objects with dictionary DOP of…

Understanding and Influencing the Optimizer

Question

Examine the parallel parameters for your instance. All parallel execution servers are available and the session use default parallelism settings. In which two cases will the degree of parallelism be automatically calculated?

Exhibit

Options

AStatements accessing tables whom dictionary DOP is 2 or more
BStatements accessing tables whose dictionary DOP is DEFAULT
CStatements that are estimated to execute for more than 10 seconds serially
DStatements accessing tables with any setting for Dictionary DOP
EStatements with parallel hints

How the community answered

(36 responses)

A
8% (3)
B
75% (27)
C
3% (1)
D
14% (5)

Explanation

Note: In earlier versions of the Oracle Database, we had to determine the DOP more or less manually, either with a parallel hint or by setting a parallel degree with alter table. There was an automatic computation of the DOP available for the objects with dictionary DOP of default, derived from the simple formula CPU_COUNT * PARALLEL_THREADS_PER_CPU.

Topics

#Auto DOP#degree of parallelism#PARALLEL_DEGREE_POLICY#parallel execution

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice