Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary Tablespace

Re: Temporary Tablespace

From: Murali Kazhipurath <murali_at_jps.net>
Date: 1997/02/04
Message-ID: <01bc127f$4b8846a0$65646464@licorice>#1/1

If your OS is Windows NT, make sure that you have applied the latest patch that was released last week.

-- 
Murali Kazhipurath
Technical Consultant
Kaustubam (Database and Internet Solutions Provider)
murali_at_jps.net
Phone # (916) 773 1918

Lando <Markl_at_plant.pnwss.com> wrote in article
<01bc1203$a268a4a0$2a868cc6_at_quebim.quebim>...

>
>
> I just upgraded our DB to 7.3 and altered tablespace temporary_data to be
> temporary. Now, if I
> understand the documentation correctly, temporary segments are supposed
to
> be deallocated
> in the temporary tablespace after completion of the statement causing the
> temporary segments
> to be created. However, if I look at the amount of space used/free for
the
> temporary tablespace
> it appears if the temporary segments are not being deallocated or cleaned
> up. Right now, my
> temporary TS is about 99% full with very little database activity. Is my
> interpretation of the documentation correct or am I missing something?
> Thanks for any info.
>
>
> M.Landa
>
Received on Tue Feb 04 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US