Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Space Usage in temporary tablespace

Re: Space Usage in temporary tablespace

From: PhilB <phillip.bridges_at_gmail.com>
Date: 26 Jul 2005 08:47:39 -0700
Message-ID: <1122392858.976612.264350@g43g2000cwa.googlegroups.com> 





Seeing the temporary tablespace at 100% full is not unusual.  This is
because of the way sort segments are allocated in the temp tablespace
(and not de-allocated).  The tablespace is not full in the true sense
of the word, the temporary segments are not de-allocated but marked as
free so they can be reused, maybe this is what you are seeing.
Received on Tue Jul 26 2005 - 10:47:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US