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_at_posting.google.com>
[Quoted] [Quoted] 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?
Date: 1 Dec 2001 13:20:53 -0800
Message-ID: <a5ae1554.0112011320.4165d024_at_posting.google.com>
[Quoted] [Quoted] 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?
[Quoted] 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 - 22:20:53 CET