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

KeyDatatypeRequiredDescription
sqlObjectIdstring(Required) The SQL object ID for the SQL tuning task. This is not the OCID.
attributestring(Required) The attribute of the SQL execution plan.

HEADERS

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

RESPONSES

status: OK

{&quot;plan&quot;:[{&quot;accessPredicates&quot;:&quot;\u003cstring\u003e&quot;,&quot;attribute&quot;:&quot;\u003cstring\u003e&quot;,&quot;bytes&quot;:&quot;\u003clong\u003e&quot;,&quot;cardinality&quot;:&quot;\u003clong\u003e&quot;,&quot;cost&quot;:&quot;\u003cdouble\u003e&quot;,&quot;cpuCost&quot;:&quot;\u003cdouble\u003e&quot;,&quot;filterPredicates&quot;:&quot;\u003cstring\u003e&quot;,&quot;ioCost&quot;:&quot;\u003cdouble\u003e&quot;,&quot;numberOfSearchColumn&quot;:&quot;\u003cinteger\u003e&quot;,&quot;objectName&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectNode&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectOwner&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectPosition&quot;:&quot;\u003cinteger\u003e&quot;,&quot;objectType&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;,&quot;optimizerMode&quot;:&quot;\u003cstring\u003e&quot;,&quot;options&quot;:&quot;\u003cstring\u003e&quot;,&quot;other&quot;:&quot;\u003cstring\u003e&quot;,&quot;otherTag&quot;:&quot;\u003cstring\u003e&quot;,&quot;parentStepId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;partitionId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;partitionStart&quot;:&quot;\u003cstring\u003e&quot;,&quot;partitionStop&quot;:&quot;\u003cstring\u003e&quot;,&quot;planHashValue&quot;:&quot;\u003clong\u003e&quot;,&quot;position&quot;:&quot;\u003cinteger\u003e&quot;,&quot;remarks&quot;:&quot;\u003cstring\u003e&quot;,&quot;stepId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;tempSpace&quot;:&quot;\u003clong\u003e&quot;,&quot;time&quot;:&quot;\u003clong\u003e&quot;},{&quot;accessPredicates&quot;:&quot;\u003cstring\u003e&quot;,&quot;attribute&quot;:&quot;\u003cstring\u003e&quot;,&quot;bytes&quot;:&quot;\u003clong\u003e&quot;,&quot;cardinality&quot;:&quot;\u003clong\u003e&quot;,&quot;cost&quot;:&quot;\u003cdouble\u003e&quot;,&quot;cpuCost&quot;:&quot;\u003cdouble\u003e&quot;,&quot;filterPredicates&quot;:&quot;\u003cstring\u003e&quot;,&quot;ioCost&quot;:&quot;\u003cdouble\u003e&quot;,&quot;numberOfSearchColumn&quot;:&quot;\u003cinteger\u003e&quot;,&quot;objectName&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectNode&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectOwner&quot;:&quot;\u003cstring\u003e&quot;,&quot;objectPosition&quot;:&quot;\u003cinteger\u003e&quot;,&quot;objectType&quot;:&quot;\u003cstring\u003e&quot;,&quot;operation&quot;:&quot;\u003cstring\u003e&quot;,&quot;optimizerMode&quot;:&quot;\u003cstring\u003e&quot;,&quot;options&quot;:&quot;\u003cstring\u003e&quot;,&quot;other&quot;:&quot;\u003cstring\u003e&quot;,&quot;otherTag&quot;:&quot;\u003cstring\u003e&quot;,&quot;parentStepId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;partitionId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;partitionStart&quot;:&quot;\u003cstring\u003e&quot;,&quot;partitionStop&quot;:&quot;\u003cstring\u003e&quot;,&quot;planHashValue&quot;:&quot;\u003clong\u003e&quot;,&quot;position&quot;:&quot;\u003cinteger\u003e&quot;,&quot;remarks&quot;:&quot;\u003cstring\u003e&quot;,&quot;stepId&quot;:&quot;\u003cinteger\u003e&quot;,&quot;tempSpace&quot;:&quot;\u003clong\u003e&quot;,&quot;time&quot;:&quot;\u003clong\u003e&quot;}]}