ORA-12827: insufficient parallel query slaves available



ORA-12827: insufficient parallel query slaves available..

Answer / guest

Cause: PARALLEL_MIN_PERCENT parameter was specified and
fewer than minimum slaves were acquired

Action: either re-execute query with lower
PARALLEL_MIN_PERCENT or wait until some running queries are
completed, thus freeing up slaves

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36155: (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.

1 Answers  


NID-00417: Change of database ID failed.

1 Answers  


ORA-19728: data object number conflict between table string and partition string in table string

1 Answers  


ORA-07754: slemcf: fwrite failure

1 Answers  


LPX-00007: unexpected end-of-file encountered

1 Answers  






TNS-12544: TNS:contexts have different wait/test functions

1 Answers  


ORA-28046: Password change for SYS disallowed

1 Answers  


ORA-12039: unable to use local rollback segment "string"

1 Answers  


SQL*Loader-00709: Internal error calling SLTS layer: string failed

1 Answers  


PLS-00369: no choices may appear with choice OTHERS in an exception handler

1 Answers  


ORA-38503: index already defined using the parameters

1 Answers  


ORA-19683: real and backup blocksize of file string are unequal

1 Answers  


Categories