Re: HELP: how to clean up temporary lobs

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 2 Dec 2001 07:41:06 -0800
Message-ID: <9udi2i011e5_at_drn.newsguy.com>


In article <a5ae1554.0112011320.4165d024_at_posting.google.com>, ewong_at_mail.com says...
>
>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?
>

are they freeing them when done?

http://technet.oracle.com/doc/oracle8i_816/appdev.816/a76940/adl10tm7.htm#389218

>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

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Sun Dec 02 2001 - 16:41:06 CET

Original text of this message