HDB_TABLE_SIZES - HANA Table Sizes History
HANA Table Sizes History information is stored in SAP table HDB_TABLE_SIZES.
It is part of development package SDBA_HDB in software component HAN-DB. This development package consists of objects that can be grouped under "DBACOCKPIT for NewDB (HDB)".
It is part of development package SDBA_HDB in software component HAN-DB. This development package consists of objects that can be grouped under "DBACOCKPIT for NewDB (HDB)".
Fields for table HDB_TABLE_SIZES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| COLLECT_DATE | System Date | X | SYDATUM | DATS | 16 | |
| STUNDE | *** NOT YET USED*** | X | CHAR | 4 | ||
| SCHEMA_NAME | Schema Name | X | CHAR | 256 | ||
| TABLE_NAME | Table Name | X | CHAR | 256 | ||
| OCCTB | Estimated Maximum Memory Consumption (in KB) | DEC | 11 | |||
| MEMORY_SIZE_IN_MAIN | Current Memory Consumption in Main Storage (in KB) | DEC | 11 | |||
| MEMORY_SIZE_IN_DELTA | Current Memory Consumption in Delta Storage (in KB) | DEC | 11 | |||
| MEMORY_SIZE_IN_TOTAL | Current Total Memory Consumption (in KB) | DEC | 11 | |||
| MEMORY_SIZE_IN_PERM | Current Persistent Memory Consumption (in KB) | DEC | 11 | |||
| DISK_SIZE | Size on Disk (in KB) | DEC | 11 | |||
| PARTITIONS | Number of partitions | INT4 | 4 | |||
| NROWS | Number of records in a table | DEC | 8 | |||
| INSERT_COUNT | Number of inserts in a table | DEC | 8 | |||
| DELETE_COUNT | Number of deletes in a table | DEC | 8 | |||
| UPDATE_COUNT | Number of updates in a table | DEC | 8 | |||
| REPLACE_COUNT | Number of replaces in a table | DEC | 8 |