Chuck Hamilton (Xchuckh@dvol.com) wrote:
: I'm running oracle 7.3.2 on Irix and hp-ux. I've noticed that somtimes
: temporary segments are left in the temp tablespace long after the sort or
: group-by that created them has finished. Is this normal behaviour? Does
: oracle reuse those segments?
: --
: Chuck Hamilton
: Xchuckh@dvol.com
Chuck,
It is perfectly natural for the temporary segments to linger in your
database. They will eventually go away, once the background processes
clean it up. The time it stays out there depends on how large the process
was, and the amount of rollback activity associated with the temporary
segment. As far as I know, they are never re-used.
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 115+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page