Re: Free space coalescing

First use the following command to COALESCE the freespace.

alter tablespace tablspace_name1 coalessce;

Then set the pct_increase = 1 fro the the tablespace ( not tables). It could be anything other than 0. This is what tells SMON to automatically coalesce the freespace. from this time forward the freespace will be always coalesced.

You can do this for all the tablespaces except system, rbs, tools etc.

Good luck !!!

suresh.bhat_at_mitchell-energy.com

Kevin Berry <@dircon.co.uk> wrote in article <35b3564a.0_at_newsread1.dircon.co.uk>...
> I have an ORACLE 7.3.2.3.0 database running on a DEC Unix 3.2 server that
is
> not coalescing adjacent free extents into a single larger extent.
>
> The coalescing works when creating tables or when a table is extended,
but
> the documentation I have suggests that the SMON background process also
> periodically coalesces adjacent free space. This does not seen to be
> happening. A couple of weeks ago I dropped one of the schemes in the db
and
> have just taken a look at the free extents, there are over 4000 of them
when
> there should be about half a dozen.
>
> I've looked through the various manuals and init parameters and can't
find
> anything to explain the above, so any help would be appreciated.
>
> If possible can you please reply using email
>
> Thanks
>
> Kevin
>
>
>
Received on Mon Jul 20 1998 - 13:48:28 CDT