Re: Temp tablespace storage parameters

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 18 Oct 1999 18:11:49 +0800
Message-ID: <380AF265.5990@yahoo.com>

TimSearch wrote:
>
> If you specify the tempoary attribute for your temp tablespace you would not
> want to coalese. The whole point of temporary is to allocate extents and not
> have space management release them, they are just reused.
>
> If you bounce the instance the extents are deallocated. This can be used to
> show you just how much of your temp tablespace is being allocated between
> bounces.

or just

alter tablespace temp permanent;
alter tablespace temp temporary;

will also clear them out..
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Oct 18 1999 - 05:11:49 CDT