Description

　　Error report:

　　SQL Error: ORA-12801: error signaled in parallel query server P010

　　ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

　　12801. 00000 - "error signaled in parallel query server %s"

　　*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.

　　*Comment: This error can be turned off with event 10397, in which

　　case the server's actual error is signaled instead.

Caused By

临时表空间不足。可能是子查询过多，或者中间结果过大。

Solution

1. 增加临时表空间
2. 优化 sql（创建 Index，去掉 order 等减少占用临时表空间）

References