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.