Tablespace coalesce
From: sanjay <????_at_gr.hp.com>
Date: 1996/08/16
Message-ID: <3214D845.3306_at_gr.hp.com>#1/1
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