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?

 

Oracle unable to extend temp segment by 128 in tablespace TEMP