The system table GARBAGECOLLECTOR_STATISTICS describes garbage collector activity.
GARBAGECOLLECTOR_STATISTICS
TASKID |
FIXED(10) |
ID of the task that is running as a garbage collector |
ACTIVE |
CHAR (3) |
Task is active (YES | NO) |
ACTIVE_COUNT |
FIXED(20) |
Number of times the task was activated |
DELETE_OBJ |
FIXED(20) |
Number of persistent objects released by the garbage collectors |
RELHIST_NORMAL |
FIXED(20) |
Number of history entries released by the garbage collectors |
RELHIST_SENSITIVE |
FIXED(20) |
NULL value (no longer in use) |
RELHIST_TRUNCATE |
FIXED(20) |
NULL value (no longer in use) |
HIST_CREATE_FILE |
FIXED(20) |
Number of ‘Create Container’ history entries released by the garbage collectors |
HIST_DELETE_OBJ |
FIXED(20) |
Number of ‘Delete Object’ history entries released by the garbage collectors |
HIST_DROP_FILE |
FIXED(20) |
Number of ‘Drop Container’ history entries released by the garbage collectors |
HIST_LOCK_OBJ |
FIXED(20) |
Number of ‘Lock Object’ history entries released by the garbage collectors |
HIST_INSERT_OBJ |
FIXED(20) |
Number of ‘Insert Object’ history entries released by the garbage collectors |
HIST_NEW_OBJ |
FIXED(20) |
Number of ‘New Object’ history entries released by the garbage collectors |
HIST_UPDATE_OBJ |
FIXED(20) |
Number of ‘Update Object’ history entries released by the garbage collectors |
RELPAGE_EMPTY |
FIXED(20) |
Number of pages released by the garbage collectors because they were empty |
RELPAGE_DROPFILE |
FIXED(20) |
Number of pages that were released due to a ‘Drop Container’ statement |
DROP_FILE |
FIXED(20) |
Number of ‘Drop Container’ commands carried out by the garbage collectors |
See also:
Concepts of the Database System, History Management