Showing posts with label ORA-12827. Show all posts
Showing posts with label ORA-12827. Show all posts

Saturday, 3 March 2012

ORA-12827: insufficient parallel query slaves available

ORA-12827: insufficient parallel query slaves available

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