Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: temp tablespace

RE: temp tablespace

From: Joan Hsieh <Joan.Hsieh_at_mirror-image.com>
Date: Thu, 01 Feb 2001 12:38:10 -0800
Message-ID: <F001.002A7F99.20010201122749@fatcity.com>

or take temp offline and online again.

Joan

-----Original Message-----

Rafiq
Sent: Thursday, February 01, 2001 2:12 PM To: Multiple recipients of list ORACLE-L

To resolve it now:
alter tablespace temp coalesce;

for all the time set pctincrease to 1 (if 0) of temp tablespace

alter tablespace temp default storage(pctincrease 1);

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thu, 01 Feb 2001 08:07:48 -0800

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

Get your FREE download of MSN Explorer at http://explorer.msn.com

--

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

Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.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
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: Joan Hsieh
  INET: Joan.Hsieh_at_mirror-image.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
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 Feb 01 2001 - 14:38:10 CST

Original text of this message

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