The server has a solution to the TEMP table space expansion limit

                  Problem: The server appears to expand the TEMP table space to the limit and cannot continue to expand. Solution: 1. Use the following statement to find out who is using the temporary segment

 SELECT s.username, s.sid, s.serial#, s.sql_address, s.machine, s.program, su.tablespace, Su.segtype, su.contentsFROM v$session s, v$sort_usage suWHERE s.saddr = su.session_addr;2, those processes that are using temporary segments 
SQL> Alter system kill session 'sid,serial#';3 Retract the TEMP table space 
SQL> Alter tablespace TEMP coalesce; but this method does not necessarily work, so you need the following method to assist. 1, determine the TEMP table space ts# 
 SQL> select ts#, name from sys.ts$; TS# NAME ---------------------- - 0 SYSYEM 1 RBS 2 USERS 3* TEMP 4 TOOLS 5 INDX 6 DRSYS2, perform cleanup operation 
SQL> alter session set events 'immediate trace name DROP_SEGMENTS level 4'; Note: TS# of temp tablespace is 3*, So TS#+ 1= 4 After TEMP cleanup, it feels that there is a problem with the storage parameters of the TEMP tablespace, so each time the 64K is expanded to 640K, the above problem will not occur after the modification.