Re: TEMP Segments

From: <Winnie_Liu_at_infonet.com>
Date: Mon, 15 May 2000 12:57:36 -0700
Message-Id: <10498.105688@fatcity.com>

Making the temporary tablespace offline and online again also work for me. It wakes up SMON to start cleaning up.

Winnie

"Danut Bancea" <danut_at_telepages.ca> on 05/15/2000 12:32:09 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

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:57:36 CDT