Oracle-L: Re: Clean temporary tablespace

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Thu, 13 Nov 2003 15:54:25 -0800
Message-ID: <F001.005D6993.20031113155425@fatcity.com>

8.1.6.3
SQL> select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP';

                    Extent

STATUS CONTENTS Management ALLOCATIO --------- --------- ---------- --------- ONLINE TEMPORARY DICTIONARY USER SQL> alter tablespace TEMP default storage(pctincrease 0);

Tablespace altered.

SQL> This will force the SMON to wake up and coalesce those segments which have been
used but not freed. This will work if you are using DICT.Managed temp tablespaces.
I have been using it regularly with results.

HTH
GovindanK

On Tue, 11 Nov 2003 22:24:24 -0800, "VirVit" <virvit_at_prodtorg.udm.net> said:
> Hello!
>
> How can I clean temporary tablespace? It grows up faster and faster.
>
> --
> ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit)
> Oracle 9i DBA beginner

-- 
http://www.fastmail.fm - Sent 0.000002 seconds ago
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: gkatteri_at_fastmail.fm

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Nov 13 2003 - 17:54:25 CST