RE: Unable to extend TEMP tablespace

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Mon, 09 Apr 2001 15:34:25 -0700
Message-ID: <F001.002E5C60.20010409151102@fatcity.com>

is it set to pctincrease 0?

is it set to type temporary ( vice permanent? e.g.)

what does your listener log show at that time?

are you running external ( i.e. cron'ed ) analyzes?

<==>   -----Original Message-----
<==>   From: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com]
<==>   Sent: Monday, April 09, 2001 5:46 PM
<==>   To: Multiple recipients of list ORACLE-L
<==>   Subject: Unable to extend TEMP tablespace
<==>  
<==>  
<==>   Hi there!
<==>  
<==>   I'm experiencing strange errors on our production
<==>   database in the middle of
<==>   the night. From the alert log file:
<==>  
<==>   Mon Apr 09 03:41:33 2001
<==>   ORA-1652: unable to extend temp segment by 64 in tablespace TEMP
<==>  
<==>   The deal is that nobody is accessing our system at 3:40
<==>   am! No jobs are
<==>   scheduled for that time. Basically there shouldn't
<==>   anything go on on the
<==>   server.
<==>  
<==>   Is there a way that I can find out what causes this
<==>   error? What user /
<==>   statement is generating so much temporary data?
<==>  
<==>   Is there a way to coalesce the TEMP tablespace so that
<==>   orphan temp segments
<==>   get deleted and the usage of the TEMP tablespace isn't
<==>   always up to 99%?
<==>  
<==>   This is 8.1.6 on Win2k.
<==>  
<==>   Thanks,
<==>   Helmut
<==>  
<==>  
<==>  
<==>   --
<==>   Please see the official ORACLE-L FAQ: http://www.orafaq.com
<==>   --
<==>   Author: Helmut Daiminger

<==>     INET: hdaiminger_at_vivonet.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 Mon Apr 09 2001 - 17:34:25 CDT