Shulou(Shulou.com)06/01 Report--

Two days ago, the operation and maintenance staff suddenly sent me a novel report of ORA-06512 error. The error is as follows, indicating that temp cannot be expanded:

ERR_1000001: unknown system error (ORA-01652: unable to extend temp segment by 128 in tablespace TEMP ORA-06512: at "WMSYS.WM_CONCAT_IMPL", line 31) Nested Exception is:ORA-01652: unable to extend temp segment by 128 in tablespace TEMP ORA-06512: at "WMSYS.WM_CONCAT_IMPL", line 31

You can use the following statement for temp tablespace usage:

Select * from

(select username,session_addr,sql_id,contents,segtype,blocks*8/1024/1024 gb

From gv$sort_usage order by blocks desc)

Where rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.