Qodex.ai

The API gets the optimizer statistics collection operation detailed report for the provided managed database.

GET {{baseUrl}}/managedDatabases/:managedDatabaseId/optimizerStatisticsCollectionOperations/:optimizerStatisticsCollectionOperationId

Gets a detailed report of the Optimizer Statistics Collection operation for the specified Managed Database.

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
opc-named-credential-idstringThe OCID of the Named Credential.
Acceptstring

RESPONSES

status: OK

{"database":{"id":"\u003cstring\u003e","name":"\u003cstring\u003e","dbType":"EXTERNAL_SIDB","dbSubType":"NON_CDB","dbDeploymentType":"EXADATA_CC","dbVersion":"\u003cstring\u003e","compartmentId":"\u003cstring\u003e"},"durationInSeconds":"\u003cnumber\u003e","endTime":"\u003cstring\u003e","id":"\u003cinteger\u003e","jobName":"\u003cstring\u003e","operationName":"\u003cstring\u003e","startTime":"\u003cstring\u003e","status":"COMPLETED","target":"\u003cstring\u003e","tasks":[{"target":"\u003cstring\u003e","targetType":"INDEX","timeStart":"\u003cdateTime\u003e","timeEnd":"\u003cdateTime\u003e","status":"PENDING"},{"target":"\u003cstring\u003e","targetType":"INDEX_PARTITION","timeStart":"\u003cdateTime\u003e","timeEnd":"\u003cdateTime\u003e","status":"SKIPPED"}],"completedCount":"\u003cinteger\u003e","failedCount":"\u003cinteger\u003e","inProgressCount":"\u003cinteger\u003e","timedOutCount":"\u003cinteger\u003e","totalObjectsCount":"\u003cinteger\u003e"}