HELP: how to clean up temporary lobs

From: Ed Wong <ewong_at_mail.com>
Date: 1 Dec 2001 13:20:53 -0800
Message-ID: <a5ae1554.0112011320.4165d024@posting.google.com>

We have a c + oci software running 24*7 on a database doing batch processing. One of the things it does is insert/select huge amount of blobs. I noticed it keep filling up the temporary tablespace(about 3 gb temp space usage a day). The temp lobs never get clean up unless I restart the software(session). Is there any way to clean up the temporary lobs of a particular session without terminating it?

I can only bounce the instance once a week in weekend. And that particular software needs to run 24 hours a day without termination. Thanks.

ewong Received on Sat Dec 01 2001 - 15:20:53 CST