Wayne,
Have you tried the DROP_SEGMENTS event? See the
following metalink docs:
Note: 1070504.6 "HOW TO FORCE TEMPORARY SEGMENT
CLEANUP IN ORACLE 8.X.X"
Note: 47400.1 "EVENT: DROP_SEGMENTS - Forcing cleanup
of TEMPORARY segments"
HTH,
- Anita
- "Bellefeuille, Wayne S"
<Wayne.Bellefeuille_at_allina.com> wrote:
> The problem is not the TEMP tablespace. Rather, the
> index rebuild is
> failing on finding "temp segment" space in the
> index's tablespace. This
> is because SMON doesn't seem to be cleaning the temp
> segments after the
> prior index's rebuild is done, and eventually, the
> rebuild of the
> indexes fails. However, when I restart the process
> in a few minutes,
> the index that failed before works now, but a
> different index (or
> partition) fails. This seems to point to SMON not
> working fast enough
> to clean out the temp segments before the next
> index's rebuild starts.
>
> The "wake smon" script worked great in 8.0 to fix
> this problem, but
> doesn't seem to work (or at least work fast enough)
> in 8i.
>
> Is there anything that can be done?
>
> Wayne
>
> -----Original Message-----
> Sent: Friday, September 21, 2001 8:00 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Have you tried setting the TEMP tablespaces
> PCTINCREASE value to 1 and
> then
> to 0 again?
>
> Mark
>
> -----Original Message-----
> Bellefeuille, Wayne S
> Sent: Friday, September 21, 2001 13:15
> To: Multiple recipients of list ORACLE-L
>
>
> This is the one I am running. It just doesn't seem
> to be doing the
> trick in 8i, where it worked fine for 8.0. Is that
> possible? Or do I
> need to look elsewhere for my temp segment problem?
>
> Wayne
>
> -----Original Message-----
> Sent: Thursday, September 20, 2001 3:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Steve Adams has a script, but I don't know if it
> works 8i
>
> http://www.ixora.com.au/scripts/sql/post_smon.sql
>
>
> -----Original Message-----
> Sent: Thursday, September 20, 2001 1:56 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Back in 8.0 days, we were running into space
> problems for temp segments
> while rebuilding indexes on our large partitioned
> tables. Someone on
> this list suggested that we use the "wake SMON"
> approach, which
> essentially running the following command from
> svrmgrl: noradebug
> wakeup <smon_pid>.
>
> This worked great. However, now that we have moved
> to 8i, we have
> started getting the temp segments space problem
> again. That is, this
> command doesn't seem to be doing its job anymore.
>
> Any ideas?
>
> Wayne Bellefeuille
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.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 Sun Sep 23 2001 - 10:43:43 CDT
