Réf. : Re: temp tablespace

From: <Sofiane-Ennaifar_at_cartes-bancaires.com>
Date: Thu, 01 Feb 2001 09:32:05 -0800
Message-ID: <F001.002A78EF.20010201091611@fatcity.com>

Hi,
What is the PCT increase for your Temp TBS. If PCT increase is 0, try to alter it to 1% for instance (temp segments will be dropped) then go to 0%

Sof

                                                                                       
                       
                    "Mitchell"                                                         
                       
                    <mitchell_at_com        Pour :  Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    net.ca>              cc :    (ccc : Sofiane Ennaifar/DIR/GIECB)    
                       
                                         Objet :      Re: temp tablespace              
                       
                    01/02/01                                                           
                       
                    17:07                                                              
                       
                    Veuillez                                                           
                       
                    répondre à                                                         
                       
                    ORACLE-L

Hi.

I have my daily routine to check segmetn whose next extent will not fit in the single largest free extent in the tablespace. This morning I found the my temporary tablespace is on the list .

We have 1624M assigned for the temp tablespace. As my understatd temp tablespace will extend itself as necessary and drop itself when operation is
done.

I just wonder I should increase the size or wait to see because we just have our application updated.

Mitchell

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mitchell
INET: mitchell_at_comnet.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Sofiane-Ennaifar_at_cartes-bancaires.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message