RE: TEMP Segments

From: Norwood Bradly A <Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV>
Date: Mon, 15 May 2000 15:25:49 -0400
Message-Id: <10498.105683@fatcity.com>

SMON cleans up the temp segments every 25th cycle, or around every 2 hours and 5 minutes.

-----Original Message-----
From: Danut Bancea [mailto:danut_at_telepages.ca] Sent: Monday, May 15, 2000 2:32 PM
To: Multiple recipients of list ORACLE-L Subject: Re: TEMP Segments

Hi,

I know that all temporary segments are released just when you shutdown and startup the database.

Danut,

Danut Bancea
Senior Oracle DBA

Tele-Pages Inc.
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca

Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, May 15, 2000 1:26 PM

> Running Oracle 8.0.5 on AIX...
>
> In doing rebuilds of indexes, I am blowing up with the following error:
> ORA-01652: unable to extend temp segment by 2048 in tablespace PMADTLX
>
> In retrying, the rebuild, I get this message:
> ORA-01658: unable to create INITIAL extent for segment in tablespace
PMADTLX
>
> In looking at DBA_SEGMENTS, there are a whole bunch of TEMPORARY segment
types
> hanging out in tablespace PMADTLX. I thought SMON should clean up these
> TEMPORARY segments automatically.
>
> I am assuming this is a bug in Oracle, but thought I would ask around.
>
> Anyone know a full-proof "trick" to get rid of these. I tried creating a
dummy
> table with a small INITIAL and big NEXT with MINEXTENTS 2. It blew up on
the
> NEXT extent, but did not clean up the tablespace.
>
> Wayne
>
> --
> Author: Wayne S Bellefeuill
> INET: wbellefe_at_allina.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).
>

-- 
Author: Danut Bancea
  INET: danut_at_telepages.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

Received on Mon May 15 2000 - 14:25:49 CDT