Re: Coalesce temp?

From: Naren Chintala <naren_at_att.com>
Date: 1998/02/16
Message-ID: <34E87831.5508@att.com>#1/1

You can execute the following command when the temp tablespace is fragmented.

SQL> ALTER TABLESPACE temp COALESCE;

Jeff Schramm wrote:
>
> I have a 24x7 database (version 7.3.2) that's been up for quite some time. I just
> checked dba_free_space_coalesced and noticed that my TEMP tablespace is at .5%
> coalesced. I'm thinking of setting its PCTFREE to 1 just so SMON will coalesce it,
> but I'm concerned that there may be penalties or side effects. Opinions?
Received on Mon Feb 16 1998 - 00:00:00 CST