Class SqlTuningAdvisorTaskFindingSummary

A summary of the findings of the objects in a tuning task that match a given filter. This includes the kind of findings that were reported, whether the benefits were analyzed, and the number of benefits obtained.

Inheritance

object

SqlTuningAdvisorTaskFindingSummary

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: Oci.DatabasemanagementService.Models

Assembly: OCI.DotNetSDK.Databasemanagement.dll

Syntax

public class SqlTuningAdvisorTaskFindingSummary

Properties

DbTimeBenefit

Declaration

[JsonProperty(PropertyName = "dbTimeBenefit")]
public float? DbTimeBenefit { get; set; }

Property Value

Type	Description
float?	The time benefit (in seconds) for the highest-rated finding for this object.

IsAlternativePlanFindingPresent

Declaration

[JsonProperty(PropertyName = "isAlternativePlanFindingPresent")]
public bool? IsAlternativePlanFindingPresent { get; set; }

Property Value

Type	Description
bool?	Indicates whether an alternative execution plan was reported for this SQL statement.

IsErrorFindingPresent

Declaration

[JsonProperty(PropertyName = "isErrorFindingPresent")]
public bool? IsErrorFindingPresent { get; set; }

Property Value

Type	Description
bool?	Indicates whether there is an error in this SQL statement.

IsIndexFindingPresent

Declaration

[JsonProperty(PropertyName = "isIndexFindingPresent")]
public bool? IsIndexFindingPresent { get; set; }

Property Value

Type	Description
bool?	Indicates whether an index recommendation was reported for this SQL statement.

IsMiscellaneousFindingPresent

Declaration

[JsonProperty(PropertyName = "isMiscellaneousFindingPresent")]
public bool? IsMiscellaneousFindingPresent { get; set; }

Property Value

Type	Description
bool?	Indicates whether a miscellaneous finding was reported for this SQL statement.

IsRestructureSqlFindingPresent

Declaration

[JsonProperty(PropertyName = "isRestructureSqlFindingPresent")]
public bool? IsRestructureSqlFindingPresent { get; set; }

Property Value

Type	Description
bool?	Indicates whether a restructure SQL recommendation was reported for this SQL statement.

IsSqlProfileFindingImplemented

Declaration

[JsonProperty(PropertyName = "isSqlProfileFindingImplemented")]
public bool? IsSqlProfileFindingImplemented { get; set; }

Property Value

Type	Description
bool?	Indicates whether a SQL Profile recommendation has been implemented for this SQL statement.

IsSqlProfileFindingPresent

Declaration

[JsonProperty(PropertyName = "isSqlProfileFindingPresent")]
public bool? IsSqlProfileFindingPresent { get; set; }

Property Value

Type	Description
bool?	Indicates whether a SQL Profile recommendation was reported for this SQL statement.

IsStatsFindingPresent

Declaration

[JsonProperty(PropertyName = "isStatsFindingPresent")]
public bool? IsStatsFindingPresent { get; set; }

Property Value

Type	Description
bool?	Indicates whether a statistics recommendation was reported for this SQL statement.

IsTimeoutFindingPresent

Declaration

[JsonProperty(PropertyName = "isTimeoutFindingPresent")]
public bool? IsTimeoutFindingPresent { get; set; }

Property Value

Type	Description
bool?	Indicates whether the task timed out.

ParsingSchema

Declaration

[Required(ErrorMessage = "ParsingSchema is required.")]
[JsonProperty(PropertyName = "parsingSchema")]
public string ParsingSchema { get; set; }

Property Value

Type	Description
string	The parsing schema of the object.

Remarks

Required

PerExecutionPercentage

Declaration

[JsonProperty(PropertyName = "perExecutionPercentage")]
public int? PerExecutionPercentage { get; set; }

Property Value

Type	Description
int?	The per-execution percentage benefit.

SqlKey

Declaration

[Required(ErrorMessage = "SqlKey is required.")]
[JsonProperty(PropertyName = "sqlKey")]
public string SqlKey { get; set; }

Property Value

Type	Description
string	The unique key of this SQL statement.

Remarks

Required

SqlText

Declaration

[Required(ErrorMessage = "SqlText is required.")]
[JsonProperty(PropertyName = "sqlText")]
public string SqlText { get; set; }

Property Value

Type	Description
string	The text of the SQL statement.

Remarks

Required

SqlTuningAdvisorTaskId

Declaration

[Required(ErrorMessage = "SqlTuningAdvisorTaskId is required.")]
[JsonProperty(PropertyName = "sqlTuningAdvisorTaskId")]
public long? SqlTuningAdvisorTaskId { get; set; }

Property Value

Type	Description
long?	The unique identifier of the SQL Tuning Advisor task. This is not the OCID.

Remarks

Required

SqlTuningAdvisorTaskObjectExecutionId

Declaration

[Required(ErrorMessage = "SqlTuningAdvisorTaskObjectExecutionId is required.")]
[JsonProperty(PropertyName = "sqlTuningAdvisorTaskObjectExecutionId")]
public long? SqlTuningAdvisorTaskObjectExecutionId { get; set; }

Property Value

Type	Description
long?	The execution id of the analyzed SQL object. This is not the OCID.

Remarks

Required

SqlTuningAdvisorTaskObjectId

Declaration

[Required(ErrorMessage = "SqlTuningAdvisorTaskObjectId is required.")]
[JsonProperty(PropertyName = "sqlTuningAdvisorTaskObjectId")]
public long? SqlTuningAdvisorTaskObjectId { get; set; }

Property Value

Type	Description
long?	The key of the object to which these recommendations apply. This is not the OCID.

Remarks

Required