| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help - temp tablespace growing constantly
You probably already checked this, but if you have PCTINCREASE set to
something other than 0 on the tablespace this might be contributing to the
problem.
What are the INITIAL, NEXT and PCTINCREASE settings?
-----Original Message-----
Sent: Monday, April 30, 2001 5:01 PM
To: Multiple recipients of list ORACLE-L
The temp tablespace started at 1G and grew to 29G before croaking, we have the same software running on older oracle versions without incuring the temp creep.
-----Original Message-----
Sent: Monday, April 30, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
If you have the autoextend off, you might run out of space in your temp tablespace. If you have autoextend on, your temp file will keep growing. If you have a reasonably sized tablespace, you might want to look at the queries or index creations. How big is your entire database and how large is your temp tablespace. For example, we have a database of 35.3 gig and a temp tablespace of 1.5 gig and almost never run out of space. And when we do, it is almost always a bad select that is returning too much data.
>>> jbshaw_at_ingr.com 04/30/01 01:10PM >>> No but, when I turned it off it kept running out of space.
-----Original Message-----
Sent: Friday, April 27, 2001 4:33 PM
To: Multiple recipients of list ORACLE-L
Does the temp tablespace has it's autoextend turned off?
>>> rafiq9857_at_hotmail.com 04/27/01 04:55PM >>> Under this situation try to offline temp tablespace and online it immediately.
Regards
Rafiq
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Thu, 26 Apr 2001 13:05:26 -0800
I've got a 8.05(2.6 patch on NT) db that the temp tablespace is constantly
growing. It's initially set to 1G , then grows up to around 25G before I
drop and recreate it. Called oracle support and they gave me a patch that
hasn't helped.
Anybody have some hints as to what to look for?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shaw, John B
INET: jbshaw_at_ingr.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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 Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
INET: BeilstWH_at_obg.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Tue May 01 2001 - 09:13:55 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |