Class SqlTuningAdvisorTaskSummary
The summary of a SQL Tuning Advisor task.
Inherited Members
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. |