TEMP tablespace not cleared for sessions in Web Logic connection pool

Hello everyone,

I have a problem with Oracle Web logic 12c connection pool.

When I upload a LOB to database through a session from Web Logic connection pool, after the operation is done, temporary table space is not cleared for sometime.

But this is not the behavior when we do the upload using a session created directed through JDBC (ojdbc7) as the memory used in temporary table space is released immediately once the upload is done.

In some cases, it takes a very longer time to clear the TEMP teblespace which causes out of space for new LOB operations.

We applied the solution of setting trace event 60025 explained in below Oracle document