Re: Temp Segments

vasarpota_at_my-deja.com wrote:
>
> Hi guys,
> was just reading the Oracle DBA book and wanted to clear up a couple of
> issues:
> 1) The SORE_AREA_SIZE is a system parameter and not specific to each
> user, right? Meaning, this represents the size in memory for all users
> regarding Sorts and when exceeded temporary segments are used
> 2) When should temporary segments be placed in Permanent Tablespaces?
> 3) How is the PGA used regarding Temporary Segments and sorting if at
> all?
> Thanks in advance for
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Sort_area_size is for EACH connected user - but is used incrementally - thus you won't be using up that much memory for each person as soon as they connect.

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

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