Class SqlTuningSet
Details of the Sql tuning set.
Inherited Members
Namespace: Oci.DatabasemanagementService.Models
Assembly: OCI.DotNetSDK.Databasemanagement.dll
Syntax
public class SqlTuningSet
Properties
AllSqlStatementsFetched
Declaration
[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'
|
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. |