Snapshot Information Level Table |
API Structure(s) sqlm_table |
Monitor Group Table |
Resettable |
Yes |
|
Event Information Level Table |
API Structure(s) sqlm_table_event |
|
API Element Name Element Type |
overflow_accesses counter |
Description: The number of accesses (reads and writes) to overflowed rows of this table.
Usage: Overflowed rows indicate that data fragmentation has occurred. If this number is high, you may be able to improve table performance by reorganizing the table using the REORG utility, which cleans up this fragmentation.
A row overflows if it is updated and no longer fits in the data page where it was originally written. This usually happens as a result of an update of a VARCHAR or an ALTER TABLE statement.
[ Top of Page | Table of Contents | Glossary | Index ]