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
- 增加临时表空间
- 优化 sql(创建 Index,去掉 order 等减少占用临时表空间)
References