Temp space filling up and not releasing
Hi ,
We are getting the following exception on our preproduction database server :
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-06512: at "SYS.DBMS_XMLGEN", line 176
ORA-06512: at line 1
And we felt that we are hitting thr Bug 5723140: TEMP SPACE NOT RELEASED AFTER COMMIT ON TABLE WITH XMLTYPE AND XSD
and the workaround would be
1) bounce the session to release the space.(it is not acceptable work around everytime)
or
2) alter session set event '60025 trace name context forever';
And the note stated that ( How to Release the Temp LOB Space and Avoid Hitting ORA-1652 (