Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


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



Action:


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

No comments:

Post a Comment

Thanks for your comment.