Tablespace coalesce

From: sanjay <????_at_gr.hp.com>
Date: 1996/08/16
Message-ID: <3214D845.3306_at_gr.hp.com>#1/1


Hi,

We have a tablespace that frequently experiences updates, inserts, and deletes. According to the SVRMGR % of extents and blocks coalesced this is creating significant fragmentation.

I am wondering what the Tablespace Menu item COALESCE does. It seems to rapidly change the % of extents and blocks coalesced back to 100%, but does it actually do any defraging.

Thanks in advnace,

Sanj Received on Fri Aug 16 1996 - 00:00:00 CEST

Original text of this message