Re: Temp Segments

Joe Maloney wrote:
>
> 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.

I don't think TEMP should be a permament tablespace.

Ideally it should be

• temporary
• raw (to avoid inode locking problems on Unix)
• based on a tempfile so it doesn't worry backup/recovery
• locally managed so it doesn't do nasties to space transactions

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse