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 Segments

Re: Temp Segments

From: <hotoracle_at_my-deja.com>
Date: 2000/04/03
Message-ID: <8c8php$e0a$1@nnrp1.deja.com>#1/1 






The SORT_AREA_SIZE parameter is the maximum amount of memory given to an
Oracle session for sorting before using the temporary segments.



The parameter SORT_AREA_RETAINED_SIZE is the space that will be retained
for the results of the sort.



Lastly temporary segments should never be created in PERMANENT
tablespaces only in TEMPORARY tablespaces. This is for many performance
reasons.



Ian Saunders


http://www.hot-oracle.com




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Mon Apr 03 2000 - 00:00:00 CDT












Original text of this message













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