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.

>>> [EMAIL PROTECTED] 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?

>>> [EMAIL PROTECTED] 04/27/01 04:55PM >>>
Under this situation try to offline temp tablespace and online it 
immediately.

Regards
Rafiq


Reply-To: [EMAIL PROTECTED] 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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: William Beilstein
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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: Shaw, John B
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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: William Beilstein
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Shaw, John B
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to