Snapshot Level Table |
Logical Data Grouping table |
Monitor Switch Table |
Resettable |
Yes |
|
Event Type Table |
Logical Data Grouping table_event |
|
Element Name Element Type |
page_reorgs counter | |
Description: The number of page reorganizations executed for a table.
Usage: Too many page reorganizationss can result in less than optimal insert performance. You can use the REORG TABLE utility to reorganize a table and eliminate fragmentation. You can also use the APPEND parameter for the ALTER TABLE statement to indicate that all inserts are appended at the end of a table and so avoid page reorgs.
In situations where updates to rows causes the row length to increase, the page may have enough space to accommodate the new row, but a page reorg may be required to defragment that space. Or if the page does not have enough space for the new larger row, an overflow record is created being created causing Accesses to Overflowed Records during reads. You can avoid both situations by using fixed length columns instead of varying length columns.