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.
Inherited Members
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