SAP ABAP Table DBAOPTL (DB Optimization - Table Statistics)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
⤷
SDBA (Package) DBA: Database-Independent Code
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | DBAOPTL |
|
| Short Description | DB Optimization - Table Statistics |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | S | System table, maint. only by SAP, change = modification |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
SDBA_DBSID | CHAR8 | CHAR | 8 | 0 | Database system ID | ||
| 2 | |
SDBA_OP_ID | CHAR14 | CHAR | 14 | 0 | Unique operation ID | ||
| 3 | |
SDBA_TASK | SDBA_TASK | CHAR | 30 | 0 | Task Name | ||
| 4 | |
SDBA_JOB | SDBA_JOB | NUMC | 10 | 0 | Unique Job Number in a Task | ||
| 5 | |
SDBA_TRIAL | CHAR10 | CHAR | 10 | 0 | Unique ID Number of the Suboperation | ||
| 6 | |
SDBA_UTNR | SDBA_UTNR | NUMC | 10 | 0 | Utility number within job step | ||
| 7 | |
SDBA_FID | SDBA_FUNCT | CHAR | 3 | 0 | DBA Function ID | ||
| 8 | |
SDBA_UPD | SDBA_UPD | CHAR | 14 | 0 | Update Time Stamp | ||
| 9 | |
SDBA_OBJ30 | CHAR30 | CHAR | 30 | 0 | Object of DB operation | ||
| 10 | |
SDBA_ANME | CHAR30 | CHAR | 30 | 0 | Analysis Method | ||
| 11 | |
SDBA_OPT | CHAR30 | CHAR | 30 | 0 | Analysis method | ||
| 12 | |
SDBA_TAB | CHAR12 | CHAR | 12 | 0 | Number of statistics to be checked | ||
| 13 | |
SDBA_CHK | CHAR12 | CHAR | 12 | 0 | Number of checked statistics | ||
| 14 | |
SDBA_OLD | CHAR12 | CHAR | 12 | 0 | Number of tables with statistics that need to be updated | ||
| 15 | |
SDBA_REF | CHAR12 | CHAR | 12 | 0 | Number of tables with updated statistics |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |