Class SqlTuningSet

[JsonProperty(PropertyName = "allSqlStatementsFetched")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlTuningSet.AllSqlStatementsFetchedEnum? AllSqlStatementsFetched { get; set; }

Property Value

Type	Description
SqlTuningSet.AllSqlStatementsFetchedEnum?	In OCI database management, there is a limit to fetch only 2000 rows. This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are 'Yes' or 'No' Yes - All Sql statements matching the filter criteria are fetched. No - There are more Sql statements matching the fitler criteria. User should fine tune the filter criteria to narrow down the result set.

Type

Description

SqlTuningSet.AllSqlStatementsFetchedEnum?

In OCI database management, there is a limit to fetch only 2000 rows. This flag indicates whether all Sql statements of this Sql tuning set matching the filter criteria are fetched or not. Possible values are 'Yes' or 'No'

Yes - All Sql statements matching the filter criteria are fetched.
No - There are more Sql statements matching the fitler criteria. User should fine tune the filter criteria to narrow down the result set.

Description

Declaration

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

Property Value

Type	Description
string	The description of the Sql tuning set.

ErrorMessage

Declaration

[JsonProperty(PropertyName = "errorMessage")]
public string ErrorMessage { get; set; }

Property Value

Type	Description
string	Latest execution error of the plsql that was submitted as a scheduler job.

Id

Declaration

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

Property Value

Type	Description
int?	The unique Sql tuning set identifier.

Name

Declaration

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

Property Value

Type	Description
string	The name of the Sql tuning set.

Remarks

Required

Owner

Declaration

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

Property Value

Type	Description
string	The owner of the Sql tuning set.

Remarks

Required

ScheduledJobName

Declaration

[JsonProperty(PropertyName = "scheduledJobName")]
public string ScheduledJobName { get; set; }

Property Value

Type	Description
string	Name of the Sql tuning set scheduler job.

SqlList

Declaration

[JsonProperty(PropertyName = "sqlList")]
public List<SqlInSqlTuningSet> SqlList { get; set; }

Property Value

Type	Description
List<SqlInSqlTuningSet>	A list of the Sqls associated with the Sql tuning set.

StatementCount

Declaration

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

Property Value

Type	Description
int?	Number of statements in the Sql tuning set

Status

Declaration

[JsonProperty(PropertyName = "status")]
[JsonConverter(typeof(ResponseEnumConverter))]
public SqlTuningSetStatusTypes? Status { get; set; }

Property Value

Type	Description
SqlTuningSetStatusTypes?	Current status of the Sql tuning set.

TimeCreated

Declaration

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

Property Value

Type	Description
DateTime?	The created time of the Sql tuning set.

TimeLastModified

Declaration

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

Property Value

Type	Description
DateTime?	Last modified time of the Sql tuning set.