If you do not wish to wait that long, try 'waking' up SMON. Within svrmgrl
issue, 'oradebug wakeup pid' command where pid is the pid number of SMON
from v$process.
> -----Original Message-----
> From: Norwood Bradly A [SMTP:Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV]
> Sent: Monday, May 15, 2000 3:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: TEMP Segments
>
> SMON cleans up the temp segments every 25th cycle, or around every 2 hours
> and 5 minutes.
>
> -----Original Message-----
> Sent: Monday, May 15, 2000 2:32 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> also send the HELP command for other information (like subscribing).
> --
> Author: Norwood Bradly A
> INET: Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV
>
> 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 - 15:00:30 CDT
