AMDS - Effective size of tables and indexes in the database
Effective size of tables and indexes in the database information is stored in SAP table AMDS.
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 AMDS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TNAME | Table name | X | TNAME | CHAR | 30 | * |
| ANDAT | Analysis date for application monitor | X | AM_ANDAT | DATS | 8 | |
| ACTIV | Activation flag Application monitor | AM_ACTIVS | CHAR | 2 | ||
| AMETH | Analysis Method for Collecting Statistics | AM_AMETH | CHAR | 4 | ||
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR | 5 | ||
| NROWS | Number of rows in a table | OROWS | DEC | 8 | ||
| OCCBL | Used blocks of an Oracle table | OU_BLOCKS | DEC | 6 | ||
| EMPBL | Empty blocks allocated for an Oracle table | OE_BLOCKS | 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 | ||
| INDBL | Allocated blocks for an Oracle index | OIND_ALLBL | DEC | 6 | ||
| INDBS | Total space allocated in the B tree (ORACLE) | OBTREE_SPC | DEC | 8 | ||
| INDUS | Total space used in B tree (ORACLE) | OBTREE_USE | DEC | 8 |