When session process with lob_data and get area of temp tablespace as temp lob segments. Session will not release temp lob segment area in temp tablespace until session logoff.
- In Oracle Metalink, How to Release the Temp LOB Space and Avoid Hitting ORA-1652 [Metalink ID 802897.1]) , When session logoff, temp lob segment area release in temp tablespace.
- In Oracle Metalink, (How to Release Temporary LOB Segments without Closing the JDBC Connection [Metalink ID 1384829.1]) , After temp lob segment process, If you use DBMS_LOB.FREETEMPORARY, temp area wil release.
- Also there are some action in java code. You can reuse same temp lob segment area.