Coalesce Free Space

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. Received on Thu Jun 29 2000 - 00:00:00 CDT