Tablespace Coalesce
From: Your_Name_Here <????_at_gr.hp.com>
Date: 1996/08/16
Message-ID: <3214B700.178B_at_gr.hp.com>#1/1
Date: 1996/08/16
Message-ID: <3214B700.178B_at_gr.hp.com>#1/1
All,
I have a tablespace that experiences a large number of insert, update, and delete statements. The percentage of extents and blocks coalesced often drops to 60% or so, in SVRMGR.
Is there any danger in using the menu option tablespace coalesce. What exactly does it do besides changing the percentage back to 100%? Is it a good tool for defraging.
Thanks in advance,
Sanj Received on Fri Aug 16 1996 - 00:00:00 CEST