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: Temp tablespace storage parameters

Re: Temp tablespace storage parameters

From: TimSearch <timsearch_at_aol.com>
Date: 15 Oct 1999 19:20:38 GMT
Message-ID: <19991015152038.05680.00000056@ng-ch1.aol.com> 





If you specify the tempoary attribute for your temp tablespace you would not
want to coalese.  The whole point of temporary is to allocate extents and not
have space management release them, they are just reused.



If you bounce the instance the extents are deallocated.  This can be used to
show you just how much of your temp tablespace is being allocated between
bounces.
Received on Fri Oct 15 1999 - 14:20:38 CDT












Original text of this message













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