Re: temporary

In article <80fgr4$hv3$1_at_nnrp1.deja.com>,   Nandakumar <N.Kumar_at_rocketmail.com> wrote:
> 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.

(Not sure, why you think, that I am implying that you should not do it.)

Let me re-iterate what I previously said; it is good practise to create a separate tablespace for temporary segments. Can I also add, that it is common practise. Meaning it is one of the first thnings that a new DBA learns to do, (along with keeping indexes in a separate tablespace from the tables they index).

One of the reasons for having temporary segments separated from permanent segments (e.g. tables and indexes), is that temporary segments being highly volatile, tend to fragment free space in the tablespace relatively quickly.

Another reason that having them in their own private tablespace would be, so that they can be placed on a separate disk, thereby increasing the overall speed of the database.

No doubt other readers can think of additional reasons.

> 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.
> >

>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 11 1999 - 17:08:42 CST