Re: temp tablespace

When you say v$sort_segment, you probably meant v$sort_usage which gives you session-specific info.

Yong Huang
yhuang_at_indigopool.com

Jaap W. van Dijk <j.w.vandijk_at_kpn.com> wrote in message news:01c019ad$6207aa40$942a15ac_at_HKTGN0003049994...
> Since Oracle 7.1 (3?) it is possible to create tablespaces of type
> TEMPORARY. In this tablespace you can only hold temporary segments, which
> are not removed, but instead an administration is kept which segment is
> assigned to which session (see view V$SORT__SEGMENT). This is because it
 is
> faster to keep an administration then to create and remove segments all
 the
> time.
>
> So there is no need to 'clean' your temp tablespace.
>
> Jaap.
>
> senthil <rsenthilkumar_at_my-deja.com> schreef in artikel
> <8paq7o$km8$1_at_nnrp1.deja.com>...
> > hi there,
> > my temp tablespace holds 1gb of data which is not freeing up. i am
> > unable to restart my database since its on production site. is there
> > any command clean the temp tablespace.
> > any help is appreciated.
> > thanks
> > -senthil.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
Received on Fri Sep 08 2000 - 16:11:42 CDT