insufficient parallel query slaves (requested string, available string, parallel_min_percent string)

Solution ID:ORA-12827

Type: Oracle

Cause

PARALLEL_MIN_PERCENT parameter was specified and fewer than the minimum number of slaves were acquired

Actions

Either reexecute the query with a lower PARALLEL_MIN_PERCENT or wait until some running queries are completed, thus freeing up slaves

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


http://docs.oracle.com/cd/E16655_01/server.121/e17613/parallel005.htm


https://community.oracle.com/message/10891550


https://community.oracle.com/message/10699107


https://community.oracle.com/message/9780857


https://community.oracle.com/message/3502450


https://community.oracle.com/message/3250236


Browse all solutions to database errors from Oracle, MS SQL, or MySQL