Class SqlTuningAdvisorTaskSummary

The summary of a SQL Tuning Advisor task.

Inheritance

object

SqlTuningAdvisorTaskSummary

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 SqlTuningAdvisorTaskSummary

Properties

DaysToExpire

Declaration

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

Property Value

Type	Description
int?	The number of days left before the task expires. If the value equals -1, then the task has no expiration time (UNLIMITED).

Description

Declaration

[JsonProperty(PropertyName = "description")]
public string Description { get; set; }

Property Value

Type	Description
string	The description of the SQL Tuning Advisor task.

InstanceId

Declaration

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

Property Value

Type	Description
int?	The instance ID of the SQL Tuning Advisor task. This is not the OCID.

Name

Declaration

[JsonProperty(PropertyName = "name")]
public string Name { get; set; }

Property Value

Type	Description
string	The name of the SQL Tuning Advisor task.

Owner

Declaration

[JsonProperty(PropertyName = "owner")]
public string Owner { get; set; }

Property Value

Type	Description
string	The owner of the SQL Tuning Advisor task.

RecommendationCount

Declaration

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

Property Value

Type	Description
int?	The number of recommendations provided for the SQL Tuning Advisor task.

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

TaskStatus

Declaration

[JsonProperty(PropertyName = "taskStatus")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlTuningTaskStatusTypes? TaskStatus { get; set; }

Property Value

Type	Description
SqlTuningTaskStatusTypes?	The status of the SQL Tuning Advisor task.

TimeCreated

Declaration

[JsonProperty(PropertyName = "timeCreated")]
public DateTime? TimeCreated { get; set; }

Property Value

Type	Description
DateTime?	The Creation date of the SQL Tuning Advisor task.

TimeExecutionEnded

Declaration

[JsonProperty(PropertyName = "timeExecutionEnded")]
public DateTime? TimeExecutionEnded { get; set; }

Property Value

Type	Description
DateTime?	The end time of the task execution.

TimeExecutionStarted

Declaration

[JsonProperty(PropertyName = "timeExecutionStarted")]
public DateTime? TimeExecutionStarted { get; set; }

Property Value

Type	Description
DateTime?	The start time of the task execution.

TotalSqlStatements

Declaration

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

Property Value

Type	Description
int?	The total number of SQL statements related to the SQL Tuning Advisor task.