Oracle Error ORA-12827: insufficient parallel query slaves (requested string, available string, parallel_min_percent string)

Oracle Error Message

ORA-12827: insufficient parallel query slaves (requested string, available string, parallel_min_percent string)

Reason for the Error

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

Solution

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