DBSTATHORA - Actual size of tables on the database (history)
Actual size of tables on the database (history) information is stored in SAP table DBSTATHORA.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table DBSTATHORA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
TNAME | Table name | X | TNAME | CHAR | 60 | * |
ANDAT | Update Time Stamp | X | SDBA_UPD | CHAR | 28 | |
VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 4 | ||
AMETH | Analysis Method for Collecting Statistics | AM_AMETH | CHAR | 8 | ||
OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR | 10 | ||
NROWS | Number of rows in a table | OROWS | DEC | 8 | ||
OCCBL | Used blocks of a table in KB | UBLOCKS_KB | DEC | 6 | ||
EMPBL | Empty blocks of a table in kb | EBLOCKS_KB | DEC | 6 | ||
AFREE | Avg. freespace in a used data base block | OAVG_BFREE | INT4 | 4 | ||
CHAIN | Number of rows requiring block chaining | OCHAINED | DEC | 8 | ||
AROWL | Average row length (Oracle result) | OAVG_ROW_L | DEC | 4 | ||
HWMBL | Empty blocks (kb) above High Water Mark | HWBLKS_KB | DEC | 6 | ||
INDBS | Used blocks of an index-Btree (kb) | BBLOCKS_KB | DEC | 8 |