Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tablespace near 100% full, smon is not freeing up, Oracle 7.3.4.5 ----> URGENT
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 ...Received on Fri Jan 10 2003 - 14:54:40 CST
>
>alter tablespace TEMP permanent;
>alter tablespace TEMP temporary;
>