Retrieve a SQL execution plan for a SQL being tuned.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningAdvisorTasks/:sqlTuningAdvisorTaskId/sqlExecutionPlan?sqlObjectId=<long>&attribute=USING_PARALLEL_EXECUTION
Retrieves a SQL execution plan for the SQL being tuned.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
sqlObjectId | string | (Required) The SQL object ID for the SQL tuning task. This is not the OCID. | |
attribute | string | (Required) The attribute of the SQL execution plan. |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"plan":[{"accessPredicates":"\u003cstring\u003e","attribute":"\u003cstring\u003e","bytes":"\u003clong\u003e","cardinality":"\u003clong\u003e","cost":"\u003cdouble\u003e","cpuCost":"\u003cdouble\u003e","filterPredicates":"\u003cstring\u003e","ioCost":"\u003cdouble\u003e","numberOfSearchColumn":"\u003cinteger\u003e","objectName":"\u003cstring\u003e","objectNode":"\u003cstring\u003e","objectOwner":"\u003cstring\u003e","objectPosition":"\u003cinteger\u003e","objectType":"\u003cstring\u003e","operation":"\u003cstring\u003e","optimizerMode":"\u003cstring\u003e","options":"\u003cstring\u003e","other":"\u003cstring\u003e","otherTag":"\u003cstring\u003e","parentStepId":"\u003cinteger\u003e","partitionId":"\u003cinteger\u003e","partitionStart":"\u003cstring\u003e","partitionStop":"\u003cstring\u003e","planHashValue":"\u003clong\u003e","position":"\u003cinteger\u003e","remarks":"\u003cstring\u003e","stepId":"\u003cinteger\u003e","tempSpace":"\u003clong\u003e","time":"\u003clong\u003e"},{"accessPredicates":"\u003cstring\u003e","attribute":"\u003cstring\u003e","bytes":"\u003clong\u003e","cardinality":"\u003clong\u003e","cost":"\u003cdouble\u003e","cpuCost":"\u003cdouble\u003e","filterPredicates":"\u003cstring\u003e","ioCost":"\u003cdouble\u003e","numberOfSearchColumn":"\u003cinteger\u003e","objectName":"\u003cstring\u003e","objectNode":"\u003cstring\u003e","objectOwner":"\u003cstring\u003e","objectPosition":"\u003cinteger\u003e","objectType":"\u003cstring\u003e","operation":"\u003cstring\u003e","optimizerMode":"\u003cstring\u003e","options":"\u003cstring\u003e","other":"\u003cstring\u003e","otherTag":"\u003cstring\u003e","parentStepId":"\u003cinteger\u003e","partitionId":"\u003cinteger\u003e","partitionStart":"\u003cstring\u003e","partitionStop":"\u003cstring\u003e","planHashValue":"\u003clong\u003e","position":"\u003cinteger\u003e","remarks":"\u003cstring\u003e","stepId":"\u003cinteger\u003e","tempSpace":"\u003clong\u003e","time":"\u003clong\u003e"}]}