Re: Table defragmentation tools

I do not know anbout defragmenting tools, but first try doing the command(s) given below on each tablespace. I think it works only on Oracle release 7.2 and above.

alter tablespace tablspace_name1 coalessce;

Then set the pct_increase = 1 for the the tablespace ( not tables). It could be anything other than 0. This is what tells SMON to automatically coalesce the freespace. SMON wakes up every couple of minutes and it may take up to about 10/15 minutes to coalesce a badly fragmented large tablespace.

alter tablespace tablespace_name1 default storage ( pctincrease 1);

From this time forward the freespace will be always coalesced and fragmentation should lessen.

You can do this for all the tablespaces except tablespaces created by Oracle such as system, rbs, tools etc.

Good luck !!!

suresh.bhat_at_mitchell-energy.com

Andy Hardy <aph_at_glink.net.hk> wrote in article <01bdb63b$0bdc6200$c70c400a_at_cms_bssup>...
> Hi,
>
> Are there any tools out there which will reliably defragment Oracle 7.3.4
> tables online?
>
> Andy
>
>
Received on Thu Jul 23 1998 - 12:17:34 CDT