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

ORA-12827是由Oracle数据库引擎在查询时发出的一条错误信息,该错误指出并行查询设置缺少一定的slave节点。

官方解释

(1)所使用的查询并行度大于系统设定的PARALLEL_MIN_PERCENT

(2)库内的可用查询并行slave少于系统设定的PARALLEL_MIN_SERVERS

常见案例

正常处理方法及步骤

(1)检查参数parallel_min_servers,如果参数低于并行查询时需要的slave数量,则改变此参数,来保证有足够的slave节点参与并行查询。

(2)检查参数parallel_slave_only,必要时修改参数值,使得低负载的查询也能自动进行并行查询。

(3)尽可能增加可用的查询并行slave,并增加PARALLEL_SLAVE_THREADS来增加slave节点的执行线程数。

你可能感兴趣的