Re: Temporary tablespace near 100% full, smon is not freeing up, Oracle 7.3.4.5 ----> URGENT

I am wondering what command can I use for a LMT temp tablespace? Not that it is important....just curious.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<avnbts$oe7$1$8302bc10_at_news.demon.co.uk>...
> The drawback to switching the tablespace
> like this (shades of the Connor Cache Hit Ratio !)
> is that if a process decides to allocate a temporary
> segment whilst the temporary tablespace is
> permanent, then you can't switch the tablespace
> back to temporary until the now permanent temporary
> segment is dropped.
>
> I believe the same effect could be achieved safely
> by the single command:
> alter tablespace temp default storage (pctincrease 0).
>
> (And, of course, the default pctincrease was zero
> anyway - but this 'no-change' change was sufficient
> to trigger a flush of the current SEP).
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Coming soon a new one-day tutorial:
> Cost Based Optimisation
> (see http://www.jlcomp.demon.co.uk/tutorial.html )
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____England______January 21/23
> ____USA_(CA, TX)_August
>
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
> Howard J. Rogers wrote in message ...
> >
> >alter tablespace TEMP permanent;
> >alter tablespace TEMP temporary;
> >
Received on Sat Jan 11 2003 - 03:37:13 CST