Kbase P16779: Why does dbanalys report a high percentage of index block spaced?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/04/2004 |
|
Status: Unverified
GOAL:
Why does dbanalys report a high percentage of index block spaced?
GOAL:
dbanalys ran after a dump and load shows a higher percentage of index block space used.
FIX:
Comparison of dbanalys before and after a dump and load shows newly loaded database with a higher percentage of index block space used.
Seeing a higher percentage of index block space used is normal when seen within a database that was newly loaded. The high percentage says that the load process of the database made most efficient use of the space that it had.