SAP Table TSPC_HIST_AVG

Oracle monitoring: tablespace history

TSPC_HIST_AVG (Oracle monitoring: tablespace history) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TSPC_HIST_AVG to other SAP tables.

TSPC_HIST_AVG table fields

Field Data element Checktable Datatype Length Decimals
FROM Oracle monitoring DB02_DATE DATS 8 0
TO Oracle monitoring DB02_DATE DATS 8 0
TABLESPACE Oracle monitoring: Tablespace DB02_TS CHAR 30 0
SIZE Oracl monitoring: size DB02_SIZE DEC 15 2
FREE Oracl monitoring: free DB02_FREE DEC 15 2
PER_USED Oracle monitoring: percentage DB02_PERC INT4 10 0
AUTOEXT Oracle monitoring: Autoextend DB02_AUTOEXT CHAR 3 0
TOT_SIZE Oracl monitoring: size DB02_SIZE DEC 15 2
TOT_FREE Oracl monitoring: free DB02_FREE DEC 15 2
TOT_PER_USED Oracle monitoring: percentage DB02_PERC INT4 10 0
FILE_NUM Oracle monitoring: number DB02_NUM INT4 10 0
SEG_NUM Oracle monitoring: number DB02_NUM INT4 10 0
EXT_NUM Oracle monitoring: decimal number DB02_DEC DEC 22 0
CHG_SIZE_AVG Oracl monitoring: size DB02_SIZE DEC 15 2
CHG_FREE_AVG Oracl monitoring: free DB02_FREE DEC 15 2
CHG_PER_USED_AVG Oracle monitoring: percentage DB02_PERC INT4 10 0
CHG_TOT_SIZE_AVG Oracl monitoring: size DB02_SIZE DEC 15 2
CHG_TOT_FREE_AVG Oracl monitoring: free DB02_FREE DEC 15 2
CHG_TOT_PER_USED_AVG Oracle monitoring: percentage DB02_PERC INT4 10 0
CHG_FILE_NUM_AVG Oracle monitoring: number DB02_NUM INT4 10 0
CHG_SEG_NUM_AVG Oracle monitoring: number DB02_NUM INT4 10 0
CHG_EXT_NUM_AVG Oracle monitoring: decimal number DB02_DEC DEC 22 0