今天在并行查询时报了ORA-12801错误,查询语句很简单:select/*+parallel(t 16)*/count(1) from a
看看官方解释:
ORA-12801: error signaled in parallel query server string
Cause: A parallel query server reached an exception condition.
Action: Check the following error message for the cause, and consult your error manual for the appropriate action.
这个解释也太抽象了,没太懂具体什么原因,最后将并行度改为8: select/*+parallel(t 8)*/count(1) from a 就OK了,估计是oracle对于你提出的并行要求无法完成,才报了这个错。。。。