Table list used by SAP ABAP Function Module DB02_ORA_TABLE_INDEX_ANALYSIS (DB02_ORA_TABLE_INDEX_ANALYSIS)
SAP ABAP Function Module 
DB02_ORA_TABLE_INDEX_ANALYSIS (DB02_ORA_TABLE_INDEX_ANALYSIS) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table |
COLUMNS_ST | DB02: dba_tab_columns (Oracle) | SOURCE DBA_TAB_COLUMNS STRUCTURE COLUMNS_ST OPTIONAL |
| 2 | Table |
DBFLAGS | Flags and Other Input Parameters for DB_ORA Modules | SOURCE VALUE(ANALYSIS) LIKE DBFLAGS-DATA_ONLY |
| 3 | Table |
DBRELEASE | Database Release | |
| 4 | Table |
DBSTATIORA | Actual size of indices on the database | |
| 5 | Table |
DBSTATIORA | Actual size of indices on the database | SOURCE VALUE(DBSTATIORA1) LIKE DBSTATIORA |
| 6 | Table |
DBSTATTORA | Actual size of tables on the database | |
| 7 | Table |
DBSTATTORA | Actual size of tables on the database | SOURCE VALUE(DBSTATTORA1) LIKE DBSTATTORA |
| 8 | Table |
DD03L | Table Fields | |
| 9 | Table |
DD03V | Table fields view | |
| 10 | Table |
DD03V | Table fields view | SOURCE DD03V_TAB STRUCTURE DD03V OPTIONAL |
| 11 | Table |
EXTENTS_ST | DB02: dba_extents (Oracle) | SOURCE DBA_EXTENTS STRUCTURE EXTENTS_ST OPTIONAL |
| 12 | Table |
INDEXES_ST | DB02: dba_indexes (Oracle) | |
| 13 | Table |
INDEXES_ST | DB02: dba_indexes (Oracle) | SOURCE VALUE(SINGLE_INDEX) LIKE INDEXES_ST |
| 14 | Table |
INDEX_STAT | index_stats Cache: Result of VALIDATE Index (Oracle) | |
| 15 | Table |
INDEX_STAT | index_stats Cache: Result of VALIDATE Index (Oracle) | SOURCE VALUE(INDEX_STATS) LIKE INDEX_STAT |
| 16 | Table |
ORACLE_RELEASE | Oracle release | |
| 17 | Table |
SEGMENTS_F | DB02: dba_segments (Oracle) | |
| 18 | Table |
SEGMENTS_F | DB02: dba_segments (Oracle) | SOURCE DBA_SEGMENTS STRUCTURE SEGMENTS_F OPTIONAL |
| 19 | Table |
SEGMENTS_F | DB02: dba_segments (Oracle) | SOURCE VALUE(DBA_SEGMENTS_TAB) LIKE SEGMENTS_F |
| 20 | Table |
SEGMENTS_F | DB02: dba_segments (Oracle) | SOURCE VALUE(BLOCK_SIZE) LIKE SEGMENTS_F-KBYTES |
| 21 | Table |
SEGMENTS_F | DB02: dba_segments (Oracle) | SOURCE VALUE(OWNER) LIKE SEGMENTS_F-OWNER OPTIONAL |
| 22 | Table |
SEGMENTS_F | DB02: dba_segments (Oracle) | SOURCE VALUE(PARTITION) LIKE SEGMENTS_F-SN OPTIONAL |
| 23 | Table |
SEGMENTS_F | DB02: dba_segments (Oracle) | SOURCE VALUE(SEG_NAME) LIKE SEGMENTS_F-SN DEFAULT '*' |
| 24 | Table |
SEGMENTS_F | DB02: dba_segments (Oracle) | SOURCE VALUE(SEG_TYPE) LIKE SEGMENTS_F-S_TYPE OPTIONAL |
| 25 | Table |
TABLES_STR | DB02: dba_tables (Oracle) | |
| 26 | Table |
TABLES_STR | DB02: dba_tables (Oracle) | SOURCE VALUE(DBA_TABLES) LIKE TABLES_STR |
