openapi: 3.0.0 info: title: SAP API version: 1.0.0 servers: - url: http://localhost:8080 paths: /rfc/DB02_ORA_LAST_ANALYZED: post: tags: - STD4 summary: 'DB02 (Oracle): Checks: Cost-based optimizer - Dates of table analysis' operationId: /rfc/DB02_ORA_LAST_ANALYZED requestBody: content: application/json: schema: properties: DBA_TAB_COLUMNS: type: array items: type: object properties: OWNER: type: string maxLength: 30 description: Owner TABLE_NAME: type: string maxLength: 30 description: Name of Object LAST_ANAL: type: string format: date description: date of the most recent analysis SAMP_SIZE: type: integer format: int64 description: sample size used in analyzing this column NUM_ROWS: type: integer format: int64 description: NUMBER OF ROWS TAB_TYPE: type: string maxLength: 11 description: Table type NR_ANALYZED: type: array items: type: object properties: DESC: type: string maxLength: 20 description: 'Oracle: Time interval when table was analyzed' SAPR3: type: integer format: int32 description: 'Oracle: No. of tables analyzed in a certain time interval' SYS: type: integer format: int32 description: 'Oracle: No. of tables analyzed in a certain time interval' SONST: type: integer format: int32 description: 'Oracle: No. of tables analyzed in a certain time interval' SDBAH_INT: type: array items: type: object properties: BEG: type: string maxLength: 14 description: Start of the DBA action FUNCT: type: string maxLength: 3 description: Function ID for DBA action SYSID: type: string maxLength: 8 description: Database System ID OBJ: type: string maxLength: 16 description: Object of DB operation RC: type: integer format: int64 description: 'Return code for DBA action enumValues: 0001=Warning,0002=General error,0000=Everything OK,0003=Detailed error' enum: - '0001' - '0002' - '0000' - '0003' ENDE: type: string maxLength: 14 description: End of database operation ACTID: type: string maxLength: 16 description: Name of DBA Log LINE: type: string maxLength: 254 description: Text Line for DBA Logs responses: '200': description: OK content: application/json: schema: properties: MULTIBLOCK_READ: type: string maxLength: 10 OPTIMIZER_MODE: type: string maxLength: 10 DBA_TAB_COLUMNS: type: array items: type: object properties: OWNER: type: string maxLength: 30 description: Owner TABLE_NAME: type: string maxLength: 30 description: Name of Object LAST_ANAL: type: string format: date description: date of the most recent analysis SAMP_SIZE: type: integer format: int64 description: sample size used in analyzing this column NUM_ROWS: type: integer format: int64 description: NUMBER OF ROWS TAB_TYPE: type: string maxLength: 11 description: Table type NR_ANALYZED: type: array items: type: object properties: DESC: type: string maxLength: 20 description: 'Oracle: Time interval when table was analyzed' SAPR3: type: integer format: int32 description: 'Oracle: No. of tables analyzed in a certain time interval' SYS: type: integer format: int32 description: 'Oracle: No. of tables analyzed in a certain time interval' SONST: type: integer format: int32 description: 'Oracle: No. of tables analyzed in a certain time interval' SDBAH_INT: type: array items: type: object properties: BEG: type: string maxLength: 14 description: Start of the DBA action FUNCT: type: string maxLength: 3 description: Function ID for DBA action SYSID: type: string maxLength: 8 description: Database System ID OBJ: type: string maxLength: 16 description: Object of DB operation RC: type: integer format: int64 description: 'Return code for DBA action enumValues: 0001=Warning,0002=General error,0000=Everything OK,0003=Detailed error' enum: - '0001' - '0002' - '0000' - '0003' ENDE: type: string maxLength: 14 description: End of database operation ACTID: type: string maxLength: 16 description: Name of DBA Log LINE: type: string maxLength: 254 description: Text Line for DBA Logs '400': description: Bad request. 5XX: description: Unexpected error.