Options
All
  • Public
  • Public/Protected
  • All
Menu

Namespace SqlTuningAdvisorTaskRecommendationSummary

A recommendation for a given object in a SQL Tuning Task.

Properties

Optional benefit

benefit: undefined | number

The percentage benefit of this implementation. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Optional finding

finding: undefined | string

Summary of the issue found in the SQL statement.

Optional implementActionSql

implementActionSql: undefined | string

Action sql to be implemented based on the recommendation result.

Optional isParallelExecution

isParallelExecution: undefined | false | true

Indicates whether a SQL Profile recommendation uses parallel execution.

Optional rationale

rationale: undefined | string

Describes the reasoning behind the recommendation and how it relates to the finding.

Optional recommendation

recommendation: undefined | string

The recommendation for a specific finding.

recommendationKey

recommendationKey: number

The unique identifier of the recommendation in the scope of the task. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

recommendationType

recommendationType: RecommendationType

Type of recommendation.

sqlTuningAdvisorTaskId

sqlTuningAdvisorTaskId: number

The unique identifier of the task. This is not the OCID. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

sqlTuningAdvisorTaskObjectId

sqlTuningAdvisorTaskObjectId: number

The key of the object to which these recommendations apply. This is not the OCID. Note: Numbers greater than Number.MAX_SAFE_INTEGER will result in rounding issues.

Functions

getDeserializedJsonObj

getJsonObj