Re: Temp Segments

Just to confues the issue, there should be a permanent tablespace, usually called TEMP, that is used just for temporary segments. The other, 'Permanent', tablespaces hold the data.

In article <8c8php$e0a$1_at_nnrp1.deja.com>, hotoracle_at_my-deja.com wrote:
> 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.
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.