Re: Temporary tablespace usage

Unfortunately, this is purely an application issue... the LOB segments
won't be released until the session terminates, *unless* they're explicitly
closed.  In our case, the only immediately viable solution was to recycle
the application (or kill the relevant SID) since so many sessions were
affected.  The long-term solution was an application-side code change, to
call DBMS_LOB.CLOSE at the appropriate times.
On Fri, Dec 16, 2011 at 16:07, Raju Angani <angani@xxxxxxxxx> wrote:

> Adric,
>
> you were spoton, when I added the segtype as you recommended, all
> those rows showed as LOB_DATA.
> Now, is there a way I can make a fix to shrink the temporary tablespace.
>
> Thank you
> RA
>


--
http://www.freelists.org/webpage/oracle-l


Other related posts: