Re: TEMP tblspc appear full, how to clean up

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sat, 18 May 2002 21:35:39 +1000
Message-ID: <ac5ech$3ev$1@lust.ihug.co.nz>

You don't get it back. Temporary segments are created during sorts and aggregations, and -just like with any other segment- once they're created, they're there for good.

Well, sort of. Uniquely, temporary segments are dropped when the database is bounced. So there's one possible cure.

SMON should also occasionally decide to wake up and coalesce free space in the temporary tablespace, provided it's genuinely free and not being used or re-used by someone else. From memory, SMON does its thing every twelve hours.

Regards
HJR "Kenny Yu" <kyu_at_biodiscovery.com> wrote in message news:ue7t0ek4d9cc1e_at_corp.supernews.com...
> At one time, O9i complained TEMP tablespace full. I checked to see 99%
used.
> I expanded it to 100 mb. It instantly used the 100 mb. The usage mark has
> stayed at 99% ever since. A guy was running a big nested select with
> aggregation. I figure some data is staying there. How do I reclaim the
> space?
>
>
Received on Sat May 18 2002 - 06:35:39 CDT