Accesses to Overflowed Records



Snapshot Level
Table


Logical Data Grouping
table


Monitor Switch
Table


Resettable


Yes


 


Event Type
Table


Logical Data Grouping
table_event


 


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.