Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary Tablespace
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>...Received on Tue Feb 04 1997 - 00:00:00 CST
>
>
> 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
>