An application accessing your database got the following error in response to SQL query: ORA-12827: insufficient parallel query slaves available View the parallel parameters for your instance: No…

Question

Exhibit

Options

• ASet PARELLEL_DEGREE_POLICY to AUTO.
• BIncrease the value of PARELLEL_MAX_SERVERS.
• CIncrease PARELLEL_SERVERS_TARGET.
• DDecrease PARELLEL_MIN_PERCENT.
• EIncrease PARELLEL_MIN_SERVERS.
• FDecrease PARELLEL_MIN_TIME_THRESHOLD.
• GIncrease PARELLEL__MIN_TIME_THRESHOLD.

• A
  82% (27)
• B
  6% (2)
• E
  9% (3)
• F
  3% (1)

Explanation

C: 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. By default, PARALLEL_SERVER_TARGET is set lower than the maximum number of parallel server processes allowed on the system (PARALLEL_MAX_SERVERS) to ensure each parallel statement will get all of the parallel server resources required and to prevent overloading the system with parallel server processes. Note: ORA-12827: insufficient parallel query slaves available Cause: PARALLEL_MIN_PERCENT parameter was specified and fewer than minimum slaves were Action: either re-execute query with lower PARALLEL_MIN_PERCENT or wait until some running queries are completed, thus freeing up slaves A, G: 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.

No community discussion yet for this question.