Oracle unable to extend temp segment by 128 in tablespace TEMP

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

• ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM: How to extend?

 

转载于:https://www.cnblogs.com/yuxiaoqi/p/4818420.html