DBTMPORA - DB Optimizer Control (Statistics Creation)
DB Optimizer Control (Statistics Creation) information is stored in SAP table DBTMPORA.
It is part of development package SDBA in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "DBA: Database-Independent Code".
It is part of development package SDBA in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "DBA: Database-Independent Code".
Fields for table DBTMPORA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DBOBJ | Name of Database Object | X | AM_DBOBJ | CHAR | 30 | |
| DOTYP | Type of Database Object | X | AM_DOTYP | CHAR | 2 | |
| OBJOW | Owner of the Database Object | X | AM_DBOWN | CHAR | 30 | |
| DBTYP | Database | X | DBSYSTEM | CHAR | 10 | |
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 2 | ||
| ACTIV | Control Flag for Update of Statistics | AM_ACTVE | CHAR | 1 | ||
| OBJEC | Identification of EDM cluster | UDCLUID | CHAR | 10 | ||
| AEDAT | Change/Insert Date in Control Table | AM_AENDDAT | DATS | 8 | ||
| SIGNI | Significance for Collection of Statistics | AM_SIGNI | INT1 | 1 | ||
| AMETH | Analysis Method for Collecting Statistics | AM_AMETH | CHAR | 4 | ||
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR | 5 | ||
| TOBDO | TODO Flag: Create New Statistics | AM_TOBDO | CHAR | 1 | ||
| HISTO | HISTORY Flag: With History | AM_HISTO | CHAR | 1 | ||
| TDDAT | Date on Which the ToDo Flag Was Set | AM_TDDAT | DATS | 8 | ||
| DURAT | Estimated runtime of table analysis | AM_DURAT | TIMS | 6 | ||
| PLAND | Customer Flag: Customer Setting | AM_PLAND | CHAR | 1 |