Re: TEMP tablespace problem

The temp tablespace will normally appear full after a while. It won't however extend - it should only do this if people's temp usage makes it do this.

so perhaps people are staying connected all week and creating massive temp tables

there are a couple of scripts to check the contents of TEMP and see who owns the stuff

AFAIR JL had some stuff on his site - jlcomp.demon.co.uk "Guy" <ni4ni_at_hotmail.com> wrote in message news:d2eb532b.0211032251.4da02823_at_posting.google.com...
> It is temporary. This is not the problem.
>
> But thanks anyway.
>
> Guy Shilo
>
> "Alex Ivascu" <alex_at_ivascu.comNOSPAM> wrote in message
news:<F4ex9.22011$bG.14537_at_rwcrnsc53>...
> > Make sure that the tablespace type is 'TEMPORARY'.
> >
> > (select tablespace_name,contents from dba_tablespaces ;)
> >
> > Alex Ivascu
> >
> >
> >
> > "Guy" <ni4ni_at_hotmail.com> wrote in message
> > news:d2eb532b.0211030604.444ce2da_at_posting.google.com...
> > > Hello
> > >
> > > Ive been dealing with Oracle for few years now, but havent seen this
> > > kind of problem before.
> > >
> > > When I install a new DB, I usually set a TEMP tablespace with
> > > 200-500MB of space. And unless the database has really huge sorts,
> > > this works fine.
> > > Now I got a DB that was installed by someone else. The TEMP tablespace
> > > grows and grows and it seems like it isnt cleaned at all. If I set a
> > > size limit (say 500 MB) it eats it up in 2-3 days and then it gets
> > > stuck with full tablespace. If I set it to auto-extend it continues to
> > > grow and in about a week I end up with a 14 GB tablespace (then I have
> > > to recreate it).
> > >
> > > Does anyone have an idea why this happens ? or any solution ?
> > > Doesnt TEMP tablespace supposed to clean unnecessary data ?
Received on Mon Nov 04 2002 - 04:53:44 CST