The following table summarizes how the compaction process affects data rows contained in the specified tables.

Table 1. System tables and the compaction process
System table What happens to table data during compaction
Sys_CPU The averages will be stored.
Sys_Dev This is a multi-row table. The key to this table is Sample_ID and Device Name.
Sys_Mem The content reflects a mixing of compaction and averages.
Sys_FileSize This is a multi-row table in which averages are stored. The key to this table is Sample_ID and Name 2 additional fields—Max and Min.
Sys_FileSys This is a multi-row table in which averages are stored. The key to this table is Sample_ID and Mount.
Sys_Process This is a multi-row table. The key to this table is Sample_ID and Process PID.