Table/Structure Field list used by SAP ABAP Function Module DB02_ORA_LAST_ANALYZED (DB02 (Oracle): Checks: Cost-based optimizer - Dates of table analysis)
SAP ABAP Function Module 
DB02_ORA_LAST_ANALYZED (DB02 (Oracle): Checks: Cost-based optimizer - Dates of table analysis) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
NRANALYZED - SAPR3 | Oracle: No. of tables analyzed in a certain time interval | |
| 2 | Table/Structure Field |
NRANALYZED - SONST | Oracle: No. of tables analyzed in a certain time interval | |
| 3 | Table/Structure Field |
NRANALYZED - SYS | Oracle: No. of tables analyzed in a certain time interval | |
| 4 | Table/Structure Field |
NRANALYZED - DESC | Oracle: Time interval when table was analyzed | |
| 5 | Table/Structure Field |
ORACLE_RELEASE - R1 | Oracle release number | |
| 6 | Table/Structure Field |
ORACLE_RELEASE - R2 | Oracle release number | |
| 7 | Table/Structure Field |
ORACLE_RELEASE - R3 | Oracle release number | |
| 8 | Table/Structure Field |
ORATABCOLS - OWNER | Owner | |
| 9 | Table/Structure Field |
ORATABCOLS - TABLE_NAME | Name of Object | |
| 10 | Table/Structure Field |
ORATABCOLS - SAMP_SIZE | sample size used in analyzing this column | |
| 11 | Table/Structure Field |
ORATABCOLS - NUM_ROWS | NUMBER OF ROWS | |
| 12 | Table/Structure Field |
ORATABCOLS - LAST_ANAL | date of the most recent analysis | |
| 13 | Table/Structure Field |
SDBAH - ENDE | End of database operation | |
| 14 | Table/Structure Field |
SDBAH - FUNCT | Function ID for DBA action | |
| 15 | Table/Structure Field |
SDBAH - OBJ | Object of DB operation | |
| 16 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 17 | Table/Structure Field |
SYST - DBSYS | ABAP System Field: Central Database System | |
| 18 | Table/Structure Field |
TST04HELP - OPTMODE | Oracle: Optimizer mode (rule/choose) | SOURCE VALUE(MULTIBLOCK_READ) LIKE TST04HELP-OPTMODE |
| 19 | Table/Structure Field |
TST04HELP - OPTMODE | Oracle: Optimizer mode (rule/choose) | SOURCE VALUE(OPTIMIZER_MODE) LIKE TST04HELP-OPTMODE |
