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 near 100% full, smon is not freeing up, Oracle 7.3.4.5 ----> URGENT

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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 10 Jan 2003 20:54:40 -0000
Message-ID: <avnbts$oe7$1$8302bc10@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 Fri Jan 10 2003 - 14:54:40 CST

Original text of this message

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