Re: temporary

Nandakumar,

Yes there are advantages in using a tablespace that is set to type temporary. It is down to the overhead involved in allocating and deallocating temporary segments, and the load this puts on the space transaction latch. In a temporary tablespace, this overhead is minimal, but in a 'normal' tablespace there is a much bigger overhead .

HTH NeilC

Nandakumar wrote in message <80fgr4$hv3$1_at_nnrp1.deja.com>...
>if that is the fact, aren't there any advantages in using the temporary
>segments from a TEMPORARY TABLESPACE rather than PERMANENT TABLESPACE? i
>guess there should be some.
>
>thanks &
>regards
>Nanda
>
>
>In article <80f996$bv2$1_at_nnrp1.deja.com>,
> Ben Ryan <benryan_at_my-deja.com> wrote:
>> In article <80f679$9gv$1_at_nnrp1.deja.com>,
>> Nandakumar <N.Kumar_at_rocketmail.com> wrote:
>> > Isn't it necessary to have one TEMPORARY tablespace in a database?
>> > I don't find any tablespace with CONTENTS - TEMPORARY in my 'working
>> > fine' database.
>>
>> Good practise, yes. Essential no.
>>
>> By default Oracle uses the system tablespace for temporary segments.
>>
>> Oracle defines which tablespace will be used for temporary segments
>> on a per user basis, rather than as a database wide attribute. So to
>> detemine which tablespace(s) is (are) being used is matter of looking
>> at the temporary_tablespace column of the dba_users table.
>>
>> The temporary attribute of a tablespace means that the tablespace
>> is reserved for temporary segments. However, this does not
>> necessarily mean anyone is using the tablespace.
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>>
>
>--
>Nandakumar
>(N.Kumar_at_rocketmail.com)
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Nov 12 1999 - 02:43:40 CST