Re: HELP: how to clean up temporary lobs
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 CorpReceived on Sun Dec 02 2001 - 16:41:06 CET