Re: Coalesce Free Space

There are no downsides that I am aware of.

Only upsides

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
Kingdom)
                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
<thiko_at_my-deja.com> wrote in message news:8jf0p0$r7c$1_at_nnrp1.deja.com...


> Hi

>

> I have queried this on our database:

>

> SELECT tablespace_name, total_blocks,

> blocks_coalesced, percent_blocks_coalesced

> FROM dba_free_space_coalesced

> WHERE percent_blocks_coalesced<>100;

>

> and have found that yes we do have adjacent free extents in the

> database.  I now would like to issue this command to coalesce them:

>

> ALTER TABLESPACE <tablespace_name> COALESCE;

>

> I would like to know what the down side (if any) of doing this is.

> Especially if it is quite a large database. e.g will anything become

> unavaliable, will things slow down?  Is it a good idea?

>

> Thanks

>

> Thiko!

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.