See the code fragment: You receive the following error message: ORA-12827: insufficient parallel query slaves available. Which three parameter settings could you change to avoid this error?

Question

Exhibit

Options

• ADecrease the value of PARALLEL_MIN_PERCENT
• BIncrease the value of PARALLEL_MAX_SERVERS
• CIncrease the value of PARALLEL_MIN_SERVERS
• DReduce the value of PARALLEL_MIN_TIME_THRESHOLF
• EIncrease the value of PARALLEL_DEGREE_LIMIT
• FSet the PARALLEL_DEGREE_POLICY = AUTO
• GSet the PARALLEL_DEGREE_POLICY = LIMITED

• A
  71% (25)
• C
  6% (2)
• D
  3% (1)
• E
  3% (1)
• F
  17% (6)

Explanation

insufficient parallel query slaves available Cause: PARALLEL_MIN_PERCENT parameter was specified and fewer than minimum slaves Action: either re-execute query with lower PARALLEL_MIN_PERCENT or wait until some running queries are completed, thus freeing up slaves B: Your query doesn't run because you've told Oracle not to run it unless at least 5% of the parallel execution processes are available for your query. Set PARALLEL_MIN_PERCENT=0 or increase the number of parallel execution processes by increasing the PARALLEL_MAX_SERVERS parameter. G: PARALLEL_DEGREE_POLICY 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 for some statements but statement queuing and in- memory Parallel Execution are disabled. Automatic degree of parallelism is only applied to those statements that access tables or indexes decorated explicitly with the PARALLEL clause. Tables and indexes that have a degree of parallelism specified will use that degree of parallelism. PARALLEL_MIN_PERCENT operates in conjunction with PARALLEL_MAX_SERVERS and PARALLEL_MIN_SERVERS. It lets you specify the minimum percentage of parallel execution processes (of the value of PARALLEL_MAX_SERVERS) required for parallel execution. Setting this parameter ensures that parallel operations will not execute sequentially unless adequate resources are available. The default value of 0 means that no minimum percentage of processes Consider the following settings: PARALLEL_MIN_PERCENT = 50 PARALLEL_MIN_SERVERS = 5 PARALLEL_MAX_SERVERS = 10 If 8 of the 10 parallel execution processes are busy, only 2 processes are available. If you then request a query with a degree of parallelism of 8, the minimum 50% will not be met. You can use this parameter in conjunction with PARALLEL_ADAPTIVE_MULTI_USER. In a multi-user environment, an individual user or application can set PARALLEL_MIN_PERCENT to a minimum value until sufficient resources are available on the system and an acceptable degree of parallelism is returned.

No community discussion yet for this question.