GARBAGECOLLECTOR_STATISTICS

Definition

The system table GARBAGECOLLECTOR_STATISTICS describes garbage collector activity.

Structure

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